Performing Insert, Update, Delete in XML in ASP.Net

Step 7: Press F7 to open the source code of the application.

Now, we need to bind the Grid View from our XML file to generate the data source. So, create a method named Get_Xml() and call the method in the Page_Load() event in your source code as shown below:

Step 8: Press Ctrl+F5 to run the application.

Step 9: Now, we perform the insert event by executing the code as shown below:

Step 10: Performing the Edit, Update and Delete operations:

• Edit
  
  1. protected void XmlGridView_RowEditing(object sender, GridViewEditEventArgs e)
  2. {
  3. XmlGridView.EditIndex = e.NewEditIndex;
  4. Get_Xml();
  5. }
  6. protected void XmlGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
  7. {
  8. XmlGridView.EditIndex = -1;
  9. Get_Xml();
  10. }

• Update
  

  1. protected void XmlGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
  2. {
  3. int id = XmlGridView.Rows[e.RowIndex].DataItemIndex;
  4. TextBox Name = XmlGridView.Rows[e.RowIndex].FindControl("TxtEditStuName") as TextBox;
  5. TextBox Course = XmlGridView.Rows[e.RowIndex].FindControl("TxtEditStuCourse") as TextBox;
  6. TextBox College = XmlGridView.Rows[e.RowIndex].FindControl("TxtEditStuCollege") as TextBox;
  7. XmlGridView.EditIndex = -1;
  8. Get_Xml();
  9. DataSet ds = XmlGridView.DataSource as DataSet;
  10. ds.Tables[0].Rows[id]["Name"] = Name.Text;
  11. ds.Tables[0].Rows[id]["Course"] = Course.Text;
  12. ds.Tables[0].Rows[id]["College"] = College.Text;
  13. ds.WriteXml(Server.MapPath("~/MyXmlFile.xml"));
  14. Get_Xml();
  15. }

• Delete
  

  1. protected void XmlGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
  2. {
  3. Get_Xml();
  4. DataSet ds = XmlGridView.DataSource as DataSet;
  5. ds.Tables[0].Rows[XmlGridView.Rows[e.RowIndex].DataItemIndex].Delete();
  6. ds.WriteXml(Server.MapPath("~/MyXmlFile.xml"));
  7. Get_Xml();
  8. }

Step 11: Now you can perform the Edit, Update and Delete operations with the events shown above.

• Edit
  
  
  
  
• Update
  
  
  
  
• Delete
  
  

Updated XML File

Summary

With this article, you can bind a Grid View with the newly created XML file. You can also perform the Insert, Update and Delete operations in the Grid View as well as the changes made in the XML file also. Happy Coding!!