Insert delete update records in XML file -ASP.NET using c#

Insert delete update records in XML file -ASP.NET using c#

by: Saravanan Arumugam

Date: 13/06/2013

Page views:

86193

Hide demo

Download

In this article I’m going to explain how to insert delete update records in XML file using ASP.NET and C#.

What is XML?

XML was created to structure, store and transport data.

XML stands for EXtensible Markup Language
XML is a markup language much like HTML
XML was designed to carry data, not to display data
XML tags are not predefined. You must define your own tags
XML is designed to be self-descriptive
XML is a W3C Recommendation

In this article I’ll show you how to insert delete update records in lightweight XML file.

So first we should create XML file

This is sample xml data structure we have created for the demo

<?xml version="1.0" standalone="yes"?>

<name>Sachin</name>

<designation>Software Engineer</designation>

<city>Chennai</city>

<country>India</country>

</Employee>

<name>Suresh</name>

<designation>Web Developer</designation>

<city>New Delhi</city>

<country>India</country>

</Employee>

</EmployeeDetails>

Designer Source Code:

</head>

<body>

<div>

<asp:GridView ID="gvEmployee" runat="server" AutoGenerateColumns="false" ShowFooter="true"

style="margin-left: 113px" Width="1049px"

OnRowCommand="gvEmployee_OnRowCommand"

onrowcancelingedit="gvEmployee_RowCancelingEdit"

onrowdeleting="gvEmployee_RowDeleting" onrowediting="gvEmployee_RowEditing"

onrowupdating="gvEmployee_RowUpdating"

onpageindexchanging="gvEmployee_PageIndexChanging">

<asp:TemplateField HeaderText="Employee ID" HeaderStyle-Width="100px">

<asp:Label ID="lblEmpID" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"empid") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtAddEmpID" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Name" HeaderStyle-Width="100px">

<asp:TextBox ID="txtName" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"name") %>'></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="lblName" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"name") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtAddName" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Designation" HeaderStyle-Width="100px">

<asp:TextBox ID="txtDesignation" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"designation") %>'></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="lblDesignation" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"designation") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtAddDesignation" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="City" HeaderStyle-Width="100px">

<asp:TextBox ID="txtCity" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"city") %>'></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="lblCity" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"city") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtAddCity" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Country" HeaderStyle-Width="200px">

<asp:TextBox ID="txtCountry" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"country") %>' TextMode="MultiLine"></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="lblCountry" runat="server" Text='<%#DataBinder.Eval(

Container. DataItem,"country") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtAddCountry" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Action" HeaderStyle-Width="150px">

<asp:LinkButton ID="lbtnUpdate" CommandName="Update" runat="server">

Update</asp:LinkButton>

<asp:LinkButton ID="lbtnCancel" CommandName="Cancel" runat="server">

Cancel</asp:LinkButton>

</EditItemTemplate>

<asp:LinkButton ID="lbtnEdit" runat="server" CommandName="Edit">

Edit</asp:LinkButton>

<asp:LinkButton ID="lbtnDelete" runat="server" CommandName="Delete">

Delete</asp:LinkButton>

</ItemTemplate>

<asp:LinkButton ID="lbtnAdd" runat="server" CommandName="Add">

Add</asp:LinkButton>

</FooterTemplate>

</asp:TemplateField>

</Columns>

<HeaderStyle BackColor="#666666" Font-Names="Cambria" ForeColor="White"

Height="30px" />

</asp:GridView>

</div>

</form>

</body>

</html>

Code Behind:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Xml;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGrid();

}

protected void BindGrid()

{

DataSet ds = new DataSet();

DataTable dt = new DataTable();

ds.ReadXml(Server.MapPath("EmployeeDetails.xml"));

if (ds != null && ds.HasChanges())

{

gvEmployee.DataSource = ds;

gvEmployee.DataBind();

}

else

{

gvEmployee.DataBind();

}

protected void gvEmployee_OnRowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName.Equals("Add"))

{

TextBox txtAddEmpID = (TextBox)gvEmployee.FooterRow.FindControl("txtAddEmpID");

TextBox txtAddName = (TextBox)gvEmployee.FooterRow.FindControl("txtAddName");

TextBox txtAddDesignation = (TextBox)gvEmployee.FooterRow.FindControl("txtAddDesignation");

TextBox txtAddCity = (TextBox)gvEmployee.FooterRow.FindControl("txtAddCity");

TextBox txtAddCountry = (TextBox)gvEmployee.FooterRow.FindControl("txtAddCountry");

XmlDocument xmldoc = new XmlDocument();

xmldoc.Load(Server.MapPath("EmployeeDetails.xml"));

XmlElement parentelement = xmldoc.CreateElement("Employee");

XmlElement empid = xmldoc.CreateElement("empid");

XmlElement name = xmldoc.CreateElement("name");

XmlElement designation = xmldoc.CreateElement("designation");

XmlElement city = xmldoc.CreateElement("city");

XmlElement country = xmldoc.CreateElement("country");

empid.InnerText = txtAddEmpID.Text;

name.InnerText = txtAddName.Text;

designation.InnerText = txtAddDesignation.Text;

city.InnerText = txtAddCity.Text;

country.InnerText = txtAddCountry.Text;

parentelement.AppendChild(empid);

parentelement.AppendChild(name);

parentelement.AppendChild(designation);

parentelement.AppendChild(city);

parentelement.AppendChild(country);

xmldoc.DocumentElement.AppendChild(parentelement);

xmldoc.Save(Server.MapPath("EmployeeDetails.xml"));

BindGrid();

}

protected void gvEmployee_RowEditing(object sender, GridViewEditEventArgs e)

{

gvEmployee.EditIndex = e.NewEditIndex;

BindGrid();

}

protected void gvEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

BindGrid();

DataSet ds = gvEmployee.DataSource as DataSet;

ds.Tables[0].Rows[gvEmployee.Rows[e.RowIndex].DataItemIndex].Delete();

ds.WriteXml(Server.MapPath("EmployeeDetails.xml"));

BindGrid();

}

protected void gvEmployee_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int i = gvEmployee.Rows[e.RowIndex].DataItemIndex;

string Name = (gvEmployee.Rows[e.RowIndex].FindControl("txtName") as TextBox).Text;

string Designation = (gvEmployee.Rows[e.RowIndex].FindControl("txtDesignation") as TextBox).Text;

string City = (gvEmployee.Rows[e.RowIndex].FindControl("txtCity") as TextBox).Text;

string Country = (gvEmployee.Rows[e.RowIndex].FindControl("txtCountry") as TextBox).Text;

gvEmployee.EditIndex = -1;

BindGrid();

DataSet ds = (DataSet)gvEmployee.DataSource;

ds.Tables[0].Rows[i]["name"] = Name;

ds.Tables[0].Rows[i]["designation"] = Designation;

ds.Tables[0].Rows[i]["city"] = City;

ds.Tables[0].Rows[i]["country"] = Country;

ds.WriteXml(Server.MapPath("EmployeeDetails.xml"));

BindGrid();

}

protected void gvEmployee_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gvEmployee.EditIndex = -1;

BindGrid();

}

protected void gvEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gvEmployee.PageIndex = e.NewPageIndex;

BindGrid();

}

View demo

Download

http://www.dotnetfox.com/Document/1003/1003Demo1.gif

If you enjoyed this article, get email updates (it's free).

How to add edit delete update records in Grid view ASP.NET Introduction: In this article i'm going to explain how to add delete edit records in Grid view. Description: If we want to add delete edit records in grid view we should use following grid view events, 1. onrowcommand 2. onrowdeleting 3. onrowupdating 4. onrowcancelingedit 5. onrowediting Also we should use following template field in Grid View. 1.ItemTemplate : ItemTemplate is used to display rec...
How to insert edit delete update records in Grid view using WCF In this article i'm going to explain how to insert records using WCF. Windows Communication Foundation (WCF) is an extension of the .NET framework to build and run connected systems. Windows Communication Foundation provides a unified framework for building secure and reliable transacted Web services. Windows Communication Foundation combines and extends the capabilities of Distributed System...
File Upload in Gridview ASP.NETIn this article I’m going to explain how to use file upload control in grid view for uploading images or files to the server. The FileUpload control allows you to provide users with a way to send a file from their computer to the server. The control is useful for allowing users to upload images, text files or other files. Here I’ll show you how to use file upload control in gridview to upload the ...
Check or Uncheck all check box in ASP.NET Gridview using JavaScriptIn this article I’m going to explain how to add CheckBox control in Gridview to Check or Uncheck all checkbox using JavaScript. To implement this concept we have to add one Checkbox control in Gridview header template and one more checkbox control in Gridview item template. here we need to use javascript to avoid postback and change gridview row color if checkbox was checked or unchecked.
Insert delete update records in XML file -ASP.NET using c# In this article I’m going to explain how to insert delete update records in XML file using ASP.NET and C#. XML was created to structure, store and transport data. What is XML? XML stands for EXtensible Markup Language XML is a markup language much like HTML XML was designed to carry data, not to display data XML tags are not predefined. You must define your own tags
How to use DropDownList control to GridView in ASP.NET using c# In this article I’m going to explain how to use DropDownList control in ASP.NET using C#. ASP.NET allows you to use any server controls in GridView. In this article I’ll show you how to use DropDownList control in GridView. DropDownList can be used to select only one item at a time item. It’s very easy to use DropDownList control in GridView. We need to use OnRowDataBound event to bind DropDownLis...
Export GridView data to excel using ASP.NET and c# In this article I’m going to explain how to export GridView data to excel using ASP.NET and C#. Sometimes we need to export gridview data to excel. Here I’ll show you how to export GridView data to Excel by using RkLib ExportData. RKLib ExportData is a class library used to export data to excel. So here we have to create table and fetch the records to DataTable and we can export to excel.
How to use Ajax CalenderExtender in ASP.NET GridViewIn this article I’m going to explain how to use Ajax CalenderExtender in ASP.NET GridView. Today one of my blog subscriber asked me a question that’s how to use Ajax CalenderExtender in ASP.NET GridView. I hope you already know how to use Ajax CalenderExtender in normal page. There is no different to use Ajax CalenderExtender in normal page and GridView.
Create dynamic GridView or programmatically create ASP.NET GridView with dynamic BoundField In this article I’m going to explain how to create dynamic GridView or programmatically create GridView with dynamic BoundField in ASP.NET using C#. In some scenario it is necessary to create dynamic GridView with BoundField instead of static one. Here I’ll explain how to create dynamic GridView which includes dynamic BoundFiled, apply custom styles to header row and data row. After creating dyna...
How to export GridView data to PDF document in ASP.NET with C# using iTextSharpIn this article I’m going to explain how to export GridView to PDF document. Other articles related to iTextSharp. iTextSharp is a C# port of iText, and open source Java library for PDF generation and manipulation. It can be used to create PDF documents from scratch, to convert XML to PDF (using the extra XFA Worker DLL), to fill out interactive PDF forms, to stamp new content on existing PDF doc...

Comments

comments powered by Disqus

Subscribe via Email

Insert delete update records in XML file -ASP.NET using c#

cytotec abortion

Thanks for downloading..!!