XML example in asp.net OR XML CRUD operation in asp.net
Introduction:
Here
I will explain how to use XML in asp.net using c# or how to work with XML using asp.net with C#. If you want to create simple XML file with data in asp.net using c# then do following step.
we can perform CRUD operation on XML file.
So, Now I explaining CRUD operation on XML file in asp.net using c#.
Description:
In previously post I explained to
Three tier architecture in asp.net
Remove .aspx from url in asp.net
Temp table in sql
Change the column name or datatype or size in sql server
Stored procedure with paging sql server
Calling web service without adding web reference
-- > If you want to
1) insert data in XML OR
2) Update data in XML OR
3) Delete data in XML OR
4) Display data from XML file
then Do following
--> following code paste in your .aspx file
------------------------------------------------------------------------------------------------
<div>
<table border="1">
<tr>
<th>ID : </th>
<td>
<asp:TextBox runat="server"
ID="TextBox1"
/>
</td>
</tr>
<tr>
<th>FirstName : </th>
<td>
<asp:TextBox runat="server"
ID="TextBox2"
/>
</td>
</tr>
<tr>
<th>Last Name : </th>
<td>
<asp:TextBox runat="server"
ID="TextBox3"
/>
</td>
</tr>
<tr>
<th>City Name : </th>
<td>
<asp:TextBox runat="server"
ID="TextBox4"
/>
</td>
</tr>
<tr>
<th>Pincode : </th>
<td>
<asp:TextBox runat="server"
ID="TextBox5"
/>
</td>
</tr>
<tr>
<th colspan="2">
<asp:Button Text="Insert" ID="Button1" runat="server" onclick="Button1_Click" />
<asp:Button Text="Update" ID="Button2" runat="server"
onclick="Button2_Click"
/>
<asp:Button Text="Delete" ID="Button3" runat="server"
onclick="Button3_Click"
/>
</th>
</tr>
<tr>
<th colspan="2">
<asp:GridView runat="server" ID="gv" />
</asp:GridView>
</th>
</tr>
</table>
</div>
--> paste following namespace in your code behind
------------------------------------------------------------------------------------------------
using System.Xml; //required namespace
using System.IO; //required namespace
--> paste following code in your page load
------------------------------------------------------------------------------------------------
protected void Page_Load(object sender, EventArgs
e)
{
if (!IsPostBack)
{
FillGridView();
}
}
--> And also copy all following event in your code behind file
------------------------------------------------------------------------------------------------
protected void Button1_Click(object sender, EventArgs
e)
{
if (File.Exists(Server.MapPath("StudentDetail.xml")) == false)
{
CreateNewFileStruct();
//if file not exist then create file
}
else
{
InsertNewRecord();
// if file exist then insert record in xml file
}
}
private void
InsertNewRecord()
{
//this is for insert new record
XmlDocument xdoc = new
XmlDocument();
xdoc.Load(Server.MapPath("StudentDetail.xml"));
XmlElement Student = xdoc.CreateElement("Student");
XmlElement ID = xdoc.CreateElement("ID");
XmlText xmlID =
xdoc.CreateTextNode(TextBox1.Text);
XmlElement FirstName = xdoc.CreateElement("FirstName");
XmlText xmlFirstName =
xdoc.CreateTextNode(TextBox2.Text);
XmlElement LastName = xdoc.CreateElement("LastName");
XmlText xmlLastName =
xdoc.CreateTextNode(TextBox3.Text);
XmlElement City = xdoc.CreateElement("City");
XmlText xmlCity =
xdoc.CreateTextNode(TextBox4.Text);
XmlElement Pincode = xdoc.CreateElement("Pincode");
XmlText xmlPincode =
xdoc.CreateTextNode(TextBox5.Text);
ID.AppendChild(xmlID);
FirstName.AppendChild(xmlFirstName);
LastName.AppendChild(xmlLastName);
City.AppendChild(xmlCity);
Pincode.AppendChild(xmlPincode);
Student.AppendChild(ID);
Student.AppendChild(FirstName);
Student.AppendChild(LastName);
Student.AppendChild(City);
Student.AppendChild(Pincode);
xdoc.DocumentElement.AppendChild(Student);
xdoc.Save(Server.MapPath("StudentDetail.xml"));
FillGridView();
}
private void FillGridView()
{
//this is for fill gridview
System.Data.DataSet ds = new System.Data.DataSet();
ds.ReadXml(Server.MapPath("StudentDetail.xml"));
gv.DataSource = ds;
gv.DataBind();
}
private void
CreateNewFileStruct()
{
//this is create a new file
string path = Server.MapPath("StudentDetail.xml");
XmlTextWriter xtw = new
XmlTextWriter(path, null);
xtw.WriteStartDocument();
xtw.WriteStartElement("Dataset");
xtw.WriteStartElement("Student");
xtw.WriteElementString("ID",
TextBox1.Text);
xtw.WriteElementString("FirstName",
TextBox2.Text);
xtw.WriteElementString("LastName",
TextBox3.Text);
xtw.WriteElementString("City",
TextBox4.Text);
xtw.WriteElementString("Pincode",
TextBox5.Text);
xtw.WriteEndElement();
xtw.WriteEndElement();
xtw.WriteEndDocument();
xtw.Close();
}
protected void
Button3_Click(object sender, EventArgs e)
{
//this is for one Delete record from XML file
XmlDocument xdoc = new
XmlDocument();
xdoc.Load(Server.MapPath("StudentDetail.xml"));
XmlNodeList list =
xdoc.SelectNodes("/Dataset/Student");
foreach (XmlNode
item in list)
{
if (item.ChildNodes[0].InnerText == TextBox1.Text)
{
item.ParentNode.RemoveChild(item);
}
}
xdoc.Save(Server.MapPath("StudentDetail.xml"));
FillGridView();
}
protected void
Button2_Click(object sender, EventArgs e)
{
//this is for update record in XML file
XmlDocument xdoc = new
XmlDocument();
xdoc.Load(Server.MapPath("StudentDetail.xml"));
XmlNodeList list = xdoc.SelectNodes("/Dataset/Student");
foreach (XmlNode
item in list)
{
if (item.ChildNodes[0].InnerText == TextBox1.Text)
{
item.ChildNodes[1].InnerText = TextBox2.Text;
item.ChildNodes[2].InnerText =
TextBox3.Text;
item.ChildNodes[3].InnerText = TextBox4.Text;
item.ChildNodes[4].InnerText = TextBox5.Text;
}
}
xdoc.Save(Server.MapPath("StudentDetail.xml"));
FillGridView();
}
