Click here to Skip to main content
14,031,046 members
Click here to Skip to main content
Add your own
alternative version


52 bookmarked
Posted 3 Apr 2007
Licenced CPOL

Edit XML files using a GridView

, 3 Apr 2007
Rate this:
Please Sign up or sign in to vote.
Editing XML files using a GridView.

Screenshot - 027_edit_xml.jpg


This short article shows how to edit XML files using a GridView control. Additionally, the user may create new records using some text fields and a button.

The XML document

Let's take a look at the structure of the XML file:

<?xml version="1.0" standalone="yes"?>
    <name>Florian 1</name>

The document contains some records holding personal data. Each record has an ID, name, and a phone number.

The web form

First, we need some controls for the web form. We need a GridView to display, edit, and delete records from the XML file. The GridView will contain two command fields: ShowEditButton and SchowDeleteButton. To create new entries, I will use three TextBox fields for the columns of the record and a Button. Here is the code for the form:

<%@ Page Language="VB" AutoEventWireup="false" 

  CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 

<html xmlns="" >
<head runat="server">
    <title>Untitled Page</title>
    <form id="form1" runat="server">
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" PageSize="3">
                <asp:CommandField ShowEditButton="True" />
                <asp:CommandField ShowDeleteButton="True" />
        <br />
        <br />
        <br />
        <asp:TextBox ID="txtId" runat="server"></asp:TextBox>
        <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
        <asp:TextBox ID="txtTel" runat="server"></asp:TextBox><br />
        <asp:Button ID="Button1" runat="server" Text="Button" /></div>

Page_Load and PageIndexChanging

In the PageLoad event, I have to bind the XML file to the GridView. To do this, I created a routine BindGrid() as I need to bind the GridView multiple times. In the BindGrid method, PhysicalApplicationPath is used to get the complete path to the XML file. Here is the code:

Protected Sub Page_Load(ByVal sender As Object, _
          ByVal e As System.EventArgs) Handles Me.Load
   If Page.IsPostBack = False Then
   End If
End Sub

Sub BindGrid()
   Dim oDs As New DataSet
   oDs.ReadXml(Request.PhysicalApplicationPath + "XMLFile.xml")
   GridView1.DataSource = oDs
End Sub

Next, I have to create an event handler to implement paging for the GridView. This is as easy as setting the PageIndex for the GridView to e.NewPageIndex.

Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, _
         ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) _
         Handles GridView1.PageIndexChanging
   GridView1.PageIndex = e.NewPageIndex
End Sub

Deleting records

To delete records from the file is easy. I assign the DataSource from the GridView to a DataSet object. Then I delete the record the user has selected using the DeleteButton from the GridView. Lastly, I update the XML file and call BindGrid().

Protected Sub GridView1_RowDeleting(ByVal sender As Object, _
       ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) _
       Handles GridView1.RowDeleting
   Dim oDs As DataSet = GridView1.DataSource
   oDs.WriteXml(Request.PhysicalApplicationPath + "XMLFile.xml")
End Sub

Updating records

Updating records is a little bit more work. First, I need to set the EditIndex for the GridView using e.NewEditIndex and call BindGrid again. This has to be done in the RowEditing event:

Protected Sub GridView1_RowEditing(ByVal sender As Object, _
        ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) _
        Handles GridView1.RowEditing
   GridView1.EditIndex = e.NewEditIndex
End Sub

Then, I implement the RowCancelingEvent. Very simple: I just have to set the EditIndex to -1 and bind the GridView.

Protected Sub GridView1_RowCancelingEdit(ByVal sender As Object, _
       ByVal e As System.Web.UI.WebControls.GridViewCancelEditEventArgs) _
       Handles GridView1.RowCancelingEdit
   GridView1.EditIndex = -1
End Sub

Now I need to create the code for the RowUpdating event. When this event fires, I have to get the changed values for the record from the GridView controls into temporary variables. This is done using a cast (CType) from cells to textboxes. Using the method .Text returns the current value of the control. Maybe, using FindControl is much better. Anyway, here is the code:

Protected Sub GridView1_RowUpdating(ByVal sender As Object, _
         ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) _
         Handles GridView1.RowUpdating
   ' Get the new values from the GridView controls
   Dim i As Integer = GridView1.Rows(e.RowIndex).DataItemIndex
   Dim strId As String = CType(GridView1.Rows(e.RowIndex).Cells(2).Controls(0), TextBox).Text
   Dim strName As String = CType(GridView1.Rows(e.RowIndex).Cells(3).Controls(0), TextBox).Text
   Dim strTel As String = CType(GridView1.Rows(e.RowIndex).Cells(4).Controls(0), TextBox).Text
   GridView1.EditIndex = -1
   ' Update the XML file using the new values

   Dim oDs As DataSet = GridView1.DataSource
   oDs.Tables(0).Rows(i).Item(0) = strId
   oDs.Tables(0).Rows(i).Item(1) = strName
   oDs.Tables(0).Rows(i).Item(2) = strTel
   oDs.WriteXml(Request.PhysicalApplicationPath + "XMLFile.xml")
End Sub 

When I get the changed values, I reset the EditIndex to -1 and bind the GridView. Then, I assign the DataSource from the GridView to a DataSet and update the values in the DataSet. Lastly, the new DataSet is written to the XML file.

Creating new records

Lastly, I have to create new records. To do this, I use three TextBoxes and a Button. When the button is clicked, I create a DataSet from the DataSource of the GridView. Next, I call the method Tables(0).NewRow and assign the values to the created DataRow. In the end, I Add the new DataRow to the DataSet and write the XML file using oDs.WriteXml.

Protected Sub Button1_Click(ByVal sender As Object, _
           ByVal e As System.EventArgs) Handles Button1.Click
   Dim oDs As DataSet = GridView1.DataSource
   Dim oDr As DataRow = oDs.Tables(0).NewRow
   oDr("id") = txtId.Text
   oDr("name") = txtName.Text
   oDr("phone") = txtTel.Text
   oDs.WriteXml(Request.PhysicalApplicationPath + "XMLFile.xml")
End Sub

Creating new records

That's it - storing data in XML files is very easy. It is also great for deployment as we can just copy the file to the desired location. But, a short warning about this solution: it does not support transactions. The last one who stores the file will win!!!

Maybe you are interested in a screen-cast about editing XML using a GridView: (in German only).


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
Germany Germany
Florian works as consultant for change- and configuration management for about 7 years. In this environment he is often forced to work with unix, perl and shell scripts.

For more information about change- and configuration management (espacially Serena Dimensions) visit:

For video tutorials about, ajax, gridviews, ... (in german) visit:

Comments and Discussions

GeneralMy vote of 5 Pin
Syed Javed11-Apr-15 20:11
memberSyed Javed11-Apr-15 20:11 
QuestionTextBox size Pin
Member 234235527-May-12 22:30
memberMember 234235527-May-12 22:30 
GeneralMy vote of 5 Pin
omegammx210-May-12 12:01
memberomegammx210-May-12 12:01 
QuestionWhy does this code hit my app_code data? Pin
zadoka29-Aug-11 8:00
memberzadoka29-Aug-11 8:00 
GeneralSorting column and add data to the top of the row Pin
Member 784935618-Apr-11 2:52
memberMember 784935618-Apr-11 2:52 
QuestionProblem with writing in XML File Pin
Rakino15-Jul-09 22:35
memberRakino15-Jul-09 22:35 
GeneralC# Version Pin
Alavri17-May-09 19:44
memberAlavri17-May-09 19:44 
GeneralRe: C# Version Pin
priyul13-Jan-10 5:14
memberpriyul13-Jan-10 5:14 
GeneralRe: C# Version Pin
a4985058-Feb-10 9:09
membera4985058-Feb-10 9:09 
GeneralRe: C# Version Pin
regeter1-Oct-13 3:39
memberregeter1-Oct-13 3:39 
Generalthanks Pin
ashuangrish28-Jan-09 20:37
memberashuangrish28-Jan-09 20:37 
Generalsorting Pin
zamkinos18-Jan-09 1:05
memberzamkinos18-Jan-09 1:05 
GeneralThank You Pin
whereissami18-Nov-08 22:19
memberwhereissami18-Nov-08 22:19 
Generalvery good Pin
Antonio Dominici S.20-May-08 17:50
memberAntonio Dominici S.20-May-08 17:50 
Questioncouldnot save the changes to the database using the grid view in 2.0 Pin
scrapper23-Apr-08 0:02
memberscrapper23-Apr-08 0:02 
QuestionMultiple Users Deleting Rows Pin
gandalf_lives15-Apr-08 3:54
membergandalf_lives15-Apr-08 3:54 
QuestionHow to load multiple level XML file and update? Pin
machewd7-Oct-07 14:57
membermachewd7-Oct-07 14:57 
Generalthankyouby far the most easy to understand Pin
assasinatedbunny4-Oct-07 8:31
memberassasinatedbunny4-Oct-07 8:31 
GeneralRe: thankyouby far the most easy to understand Pin
fstrahberger5-Oct-07 20:29
memberfstrahberger5-Oct-07 20:29 
Questionturkish character problem? Pin
umurlu26-Apr-07 3:16
memberumurlu26-Apr-07 3:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web04 | 2.8.190419.4 | Last Updated 4 Apr 2007
Article Copyright 2007 by fstrahberger
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid