Reading And Updating data to XML file using C# in ASP.net

Introduction

Hi in this Article u r going to knw how  to read data form  XML file and binding into grid view and Updating  the new record in the same XML  file. Using Methods ReadXml () and WriteXml () Methods. In this article u also come to know how to write the data from DataSet to XML file.

Namespace: System.Xml is need to add in ur application.

Procedure:

• Reading the content of the XML file into Dataset and then bind it to Gridview.
• Add the new record to this Dataset through grid view.
• Write the Data from the Dataset to XML file.

1>Reading XML File.

Using ReadXml() Method you can read the content of the file. In this article file (data.xml) contain user information with 3 tags( Id, Name, Designation).

Code:

if (!(IsPostBack))
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("data.xml"));
Session["Data"] = ds.Tables[0];
Bind(); // binding the data to gridView(id=gvdata)
}

DataTable dt = Session["Data"] as DataTable;
DataRow dr = dt.NewRow(); 
// creating new row to add new record into datatable
TextBox t1 = (TextBox)gvData.FooterRow.FindControl("txtId");
TextBox t2 = (TextBox)gvData.FooterRow.FindControl("txtName");
TextBox t3 = (TextBox)gvData.FooterRow.FindControl("txtDsng");
dr[0] = t1.Text;
dr[1] = t2.Text;
dr[2] = t3.Text;
dt.Rows.Add(dr);
dt.AcceptChanges();

3>Writing the containt of the data from  DataTable to XML File(data.xml)

Steps:

1. Here DataTable has new record which has been added newly.

2. Using  WriteXml() Method we can Update the XML File.

3. Code:

dt.WriteXml(Server.MapPath("data.xml"));
// updating the new record into XML File
Session["Data"] = dt;
Bind(); // binding the data to gridview
gvData.EditIndex = -1;

Conclusion:

ThankYou.