Xml in asp.net

Question

Hi Friends How i can save our data(table) in xml file and retrieve it on asp.net page?

Anuja Pawar · Answer

Hi Akshay Try this html xmlns =http://www.w3.org/1999/xhtml> head id =Head1 runat =server> title > title > head > body > form id =form1 runat =server> div > table > tr > td style = width : 100px> Name: td > td style = width : 100px> asp : TextBox ID =txtName runat =server> asp : TextBox > td > tr > tr > td style = width : 100px> Location: td > td style = width : 100px> asp : TextBox ID =txtLocation runat =server> asp : TextBox > td > tr > tr > td style = width : 100px> Email: td > td style = width : 100px> asp : TextBox ID =txtEmail runat =server> asp : TextBox > td > tr > tr > td > td > td > asp : Button ID =btnSubmit runat =server OnClick =btnSubmit_Click Text =Submit /> td > tr > table > br /> asp : DataList ID =dlComments Runat =server Width =100%> ItemTemplate > hr size =0/> Name: # DataBinder .Eval(Container.DataItem name ) %> br /> E-mail: a href =mailto: # DataBinder.Eval(Container.DataItem email) %> > # DataBinder .Eval(Container.DataItem email ) %> a > br /> Location: # DataBinder .Eval(Container.DataItem location ) %> br /> Date: # DataBinder .Eval(Container.DataItem Date ) %> br /> Description: # DataBinder .Eval(Container.DataItem Description ) %> ItemTemplate > asp : DataList > div > form > body > html > After that add XML file to your application and give name as Sample.xml intially xml file like this root element is compulsary for XML files that's why I added CommentInformation in XML file that root element in XML file. xml version =  1.0  encoding =  utf-8  ?> CommentsInformation > CommentsInformation > After that add this namespace in codebehind using System.Xml; using System.Data; After that write the following code in code behind protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { //Bind xml data to datalist BindDatalist(); } } /// /// btnSubmit event is used to insert data into XML file /// /// /// protected void btnSubmit_Click( object sender EventArgs e) { XmlDocument xmldoc = new XmlDocument (); xmldoc.Load(Server.MapPath( Sample.xml )); XmlElement parentelement = xmldoc.CreateElement( Comments ); XmlElement name = xmldoc.CreateElement( Name ); name.InnerText = txtName.Text; XmlElement location = xmldoc.CreateElement( location ); location.InnerText = txtLocation.Text; XmlElement email = xmldoc.CreateElement( Email ); email.InnerText = txtEmail.Text; XmlElement date = xmldoc.CreateElement( Date ); date.InnerText = DateTime .Now.ToString(); parentelement.AppendChild(name); parentelement.AppendChild(location); parentelement.AppendChild(email); parentelement.AppendChild(Description); parentelement.AppendChild(date); xmldoc.DocumentElement.AppendChild(parentelement); xmldoc.Save(Server.MapPath( Sample.xml )); BindDatalist(); } /// /// Bind xml data to datalist /// private void BindDatalist() { XmlTextReader xmlreader = new XmlTextReader (Server.MapPath( Sample.xml )); DataSet ds = new DataSet (); ds.ReadXml(xmlreader); xmlreader.Close(); if (ds.Tables.Count != 0) { dlComments.DataSource = ds; dlComments.DataBind(); } else { dlComments.DataSource = null ; dlComments.DataBind(); } }

Satyapriya Nayak · Answer

Hi Akshay For reading xml file into gridview protected void Page_Load(object sender EventArgs e) { DataSet reportData = new DataSet(); reportData.ReadXml(Server.MapPath(test.xml)); GridView1.DataSource = reportData; GridView1.DataBind(); } For writing xml file from gridview 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; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { BindGrid(); } } protected void BindGrid() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = select * from employee; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); con.Close(); ds = new DataSet(); sqlda.Fill(ds employee); GridView1.DataSource = ds; GridView1.DataMember = employee; GridView1.DataBind(); } protected void btnsave_Click(object sender EventArgs e) { BindGrid(); ds.WriteXml(d:\employee.xml); Response.Write(Records saved as xml); } } Thanks

Vulpes · Answer

The DataTable class has two methods: WriteXml and ReadXml which can be used for this purpose. I'd check out the examples in the MSDN docs: http://msdn.microsoft.com/en-us/library/system.data.datatable_methods.aspx