CRUD Operation Using LINQ To XML Documents

1. Code For Insert Data in XML document
   
   1. protected void Insert_Click(object sender, EventArgs e)
   2. {
   3. XElement emp = new XElement("Employee",
   4. new XElement("id", txtid.Text),
   5. new XElement("name", txtname.Text),
   6. new XElement("salary",txtsalary.Text),
   7. new XElement("email",txtemail.Text),
   8. new XElement("address", txtaddress.Text));
   9. xmldoc.Root.Add(emp);
   10. xmldoc.Save("D:/Emp12.xml");
   11. BindGrid();
   12. Reset(); // For clear textbox
   14. }
   for reset():
   
   1. private void Reset()
   2. {
   3. txtid.Text = "";
   4. txtname.Text = "";
   5. txtsalary.Text = "";
   6. txtaddress.Text = "";
   7. txtemail.Text = "";
   8. txtid.Focus();
   9. }
2. Code For Find Data by Id in XML document
   
   1. protected void Find(object sender, EventArgs e)
   2. {
   3. XElement emp = xmldoc.Descendants("Employee").FirstOrDefault(p => p.Element("id").Value == txtid.Text);
   4. if (emp != null)
   5. {
   6. txtname.Text = emp.Element("name").Value;
   7. txtsalary.Text = emp.Element("salary").Value;
   8. txtemail.Text = emp.Element("email").Value;
   9. txtaddress.Text = emp.Element("address").Value;
   11. }
   12. }
3. Code For Update by Id in XML document
   
   1. protected void Update_click(object sender, EventArgs e)
   2. {
   4. XElement emp = xmldoc.Descendants("Employee").FirstOrDefault(p => p.Element("id").Value == txtid.Text);
   5. if (emp != null)
   6. {
   7. emp.Element("name").Value = txtname.Text;
   8. emp.Element("salary").Value = txtsalary.Text;
   9. emp.Element("email").Value = txtemail.Text;
   10. emp.Element("address").Value = txtaddress.Text;
   11. xmldoc.Root.Add(emp);
   12. xmldoc.Save("D:/Emp12.xml");
   13. BindGrid();
   14. Reset();
   16. }
   17. }
4. Code For Delete by Id in XML document
   
   1. protected void delete_click(object sender, EventArgs e)
   2. {
   3. XElement emp = xmldoc.Descendants("Employee").FirstOrDefault(p => p.Element("id").Value == txtid.Text);
   4. if (emp != null)
   5. {
   6. emp.Remove();
   7. xmldoc.Save("D:/Emp12.xml");
   8. BindGrid();
   9. Reset();
   10. }
   11. }

Important Question:

Difference between XElement and XDocument?

Answer: xDcument represent a whole XML Document.

xElement represent an XML element. It's part of longer document.

Hope this article helps you. Thanks for reading.