In this blog we will know how to import data from xml file
to the database.
<% @ Page Language ="C#" AutoEventWireup ="true"
CodeFile ="Default.aspx.cs"
Inherits ="_Default"
%>
<! DOCTYPE html
PUBLIC "-//W3C//DTD
XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
< html xmlns ="http://www.w3.org/1999/xhtml">
< head runat ="server">
< title > Untitled Page</ title >
</ head >
< body >
< form
id ="form1"
runat ="server">
< div >
</ div >
< br
/>
< asp : Label ID ="Label1" runat ="server"
Text ="Label"></ asp : Label >
< asp : GridView ID ="GridView1"
runat ="server">
</ asp : GridView >
< asp : Button ID ="btn_insert"
runat ="server"
onclick ="btn_insert_Click"
Text ="Insert
Records" />
< asp : Button ID ="btn_show"
runat ="server"
onclick ="btn_show_Click"
style =" height : 26px" Text ="Show Records" />
</ form >
</ body >
</ html >
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial
class _Default
: System.Web.UI.Page
{
string connStr = ConfigurationManager .ConnectionStrings["ConnectionString" ].ConnectionString;
protected void btn_insert_Click(object
sender, EventArgs e)
{
SqlConnection con = new SqlConnection (connStr);
DataSet reportData = new DataSet ();
reportData.ReadXml(Server.MapPath("test.xml" ));
SqlBulkCopy sbc = new SqlBulkCopy (con);
sbc.DestinationTableName = "employee" ;
sbc.ColumnMappings.Add("TALLY_REC_ID_CODE" ,
"empid" );
sbc.ColumnMappings.Add("CLUSTER_ID" ,
"empname" );
sbc.ColumnMappings.Add("UNIT_TYPE" ,
"empaddress" );
sbc.ColumnMappings.Add("VPRC_ID" ,
"empcity" );
sbc.ColumnMappings.Add("SHG_ID" ,
"empstate" );
sbc.ColumnMappings.Add("PIP_NO" ,
"empzip" );
sbc.ColumnMappings.Add("NAME_OF_THE_MEMBER" ,
"emplic" );
sbc.ColumnMappings.Add("TYPE_OF_LOAN" ,
"empstatus" );
sbc.ColumnMappings.Add("PRINCIPAL" ,
"empp" );
sbc.ColumnMappings.Add("INTEREST" ,
"empi" );
con.Open();
sbc.WriteToServer(reportData.Tables[0]);
con.Close();
Label1.Text = "Records
inserted successfully" ;
}
protected void btn_show_Click(object
sender, EventArgs e)
{
SqlConnection con = new SqlConnection (connStr);
con.Open();
DataSet reportData = new DataSet ();
reportData.ReadXml(Server.MapPath("test.xml" ));
GridView1.DataSource = reportData;
GridView1.DataBind();
con.Close();
}
}
Piotr MilobedzkiPosted Apr 20, 2014, 7:08 PM
Helo Satyapriya Nayak! I am having the following problem with web.config file from Import XML data.rar: "Config Error There is a duplicate 'system.web.extensions/scripting/scriptResourceHandler' section defined". Could you help me with this one, please? Thank you in advance