How to Make a New XML Document at Run-time in .NET

By
In this tutorial,I am going to create a New XML Document at Runtime. I will also perform Insertion,Deletion and Updation operation on New  XML Document. which are mentioned in below: 
  1. First Create XML Document at Run-time 
  2. Update operation is perform at same Document.
  3. Delete  operation is also perform at same Document.
There are some steps to perform this task, Please follow these steps which are given below.
Step1:- First open your visual studio-> go File->click New Website->Select ASP.NET Empty Website-> select C# Language from left window-> click OK.
see it:-

Step2:- Go Solution Explorer window->Add New Web Form (Default.aspx)->Drag and Drop Label, Text Box and Button Control from Toolbox -> Change the Control Name as shown in given below"-
see it:-

Step3:- Now Double Click on Insert Button-> Include the Namespace First which are given below:-

using System.Xml;
using System.Data;
using System.Configuration;
using System.Drawing;

Step4:- Write the following code on insert button click, which are given below:-

protected void Button1_Click(object sender, EventArgs e)
    {
        XmlDocument xdoc = new XmlDocument();
  XmlNode xdeclaration = xdoc.CreateNode(XmlNodeType.XmlDeclaration, null, null);
        xdoc.AppendChild(xdeclaration);
        XmlElement xroot = xdoc.CreateElement("Employee");
        xdoc.AppendChild(xroot);
        XmlElement emp_id = xdoc.CreateElement("eid");
        emp_id.InnerText = TextBox1.Text;
        xroot.AppendChild(emp_id);
        XmlElement emp_name = xdoc.CreateElement("ename");
        emp_name.InnerText = TextBox2.Text;
        xroot.AppendChild(emp_name);
        XmlElement emp_age = xdoc.CreateElement("eage");
        emp_age.InnerText = TextBox3.Text;
        xroot.AppendChild(emp_age);
        xdoc.Save(Server.MapPath("~/Employee.xmL"));
Label4.Text = ("Data has been successfully inserted & GENERATE the XML FILE at Runtime");
        Label4.ForeColor = Color.Red;
 }

Step5:-  Now Double click on Update Button and write the following code which is given below:-
see it:-

protected void Button2_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("~/Employee.xmL"));
        ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns[0] };
        DataRow dr = ds.Tables[0].Rows.Find(TextBox1.Text);
        dr[1] = TextBox2.Text;
        dr[2] = TextBox3.Text;
        ds.WriteXml(Server.MapPath("~/Employee.xmL"));
        Label4.Text = ("xml data has been successfully updated");
        Label4.ForeColor = Color.Red;
    }

Step6:- Now Double click on Delete Button and write the following code which is given below:-
see it:-

protected void Button3_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("~/Employee.xmL"));
        ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns[0] };
        DataRow dr = ds.Tables[0].Rows.Find(TextBox1.Text);
        dr.Delete();
        ds.WriteXml(Server.MapPath("~/Employee.xmL"));
        Label4.Text = ("xml data has been successfully deleted");
        Label4.ForeColor = Color.Red;
    }

Step7:- See all code which are written in all button(insert, update, delete) clicks and  Namespace.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Data;
using System.Configuration;
using System.Drawing;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        XmlDocument xdoc = new XmlDocument();
        XmlNode xdeclaration = xdoc.CreateNode(XmlNodeType.XmlDeclaration, null, null);
        xdoc.AppendChild(xdeclaration);
        XmlElement xroot = xdoc.CreateElement("Employee");
        xdoc.AppendChild(xroot);
        XmlElement emp_id = xdoc.CreateElement("eid");
        emp_id.InnerText = TextBox1.Text;
        xroot.AppendChild(emp_id);
        XmlElement emp_name = xdoc.CreateElement("ename");
        emp_name.InnerText = TextBox2.Text;
        xroot.AppendChild(emp_name);
        XmlElement emp_age = xdoc.CreateElement("eage");
        emp_age.InnerText = TextBox3.Text;
        xroot.AppendChild(emp_age);
        xdoc.Save(Server.MapPath("~/Employee.xmL"));
        Label4.Text = ("Data has been successfully inserted & GENERATE the XML FILE at Runtime");
        Label4.ForeColor = Color.Red;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("~/Employee.xmL"));
        ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns[0] };
        DataRow dr = ds.Tables[0].Rows.Find(TextBox1.Text);
        dr[1] = TextBox2.Text;
        dr[2] = TextBox3.Text;
        ds.WriteXml(Server.MapPath("~/Employee.xmL"));
        Label4.Text = ("xml data has been successfully updated");
        Label4.ForeColor = Color.Red;
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("~/Employee.xmL"));
        ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns[0] };
        DataRow dr = ds.Tables[0].Rows.Find(TextBox1.Text);
        dr.Delete();
        ds.WriteXml(Server.MapPath("~/Employee.xmL"));
        Label4.Text = ("xml data has been successfully deleted");
        Label4.ForeColor = Color.Red;
    }
}
  • See Default.aspx.cs File Which include all codes.


Step8:- Run the Application (press F5), Insert the data and create XML file.
see it:-

  • See, XML File and inserted data(output).


Step9:- Now again Run application for Update operation:-
see it:-
  • See the changes in XML File (output):-


Step10:- Now again Run this Application for Delete operation:-
see it:-

  • See the changes in XML File (output):-

Note:- You have seen that all the operation have been  performed successfully.
For More:-

  1. SQL Server Problem 
  2. Create XML File and Display Data from File
  3. Difference Between HTML and XML
  4. Basic elements for compiling the C# code
  5. Microsoft SQL Server
I hope this is helpful for you.
To Get the Latest  Free Updates Subscribe
Click below for download whole application:-
                 DOWNLOAD

0 comments:

Post a Comment

Powered by Blogger.