Xml file convert into database

Question

how to convert xml file into sql database using c# coding

Satyapriya Nayak · Answer

Hi Krishnagopi, Untitled Page Text="Insert Records" /> style="height: 26px" Text="Show Records" /> 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(); } } Thanks

Xml file convert into database

Answers (1)