步步为营VS 2008 + .NET 3.5(14) - XLINQ(LINQ to XML)之针对XML文件的添加、查询、更新和删除

using System; 
using System.Data; 
using System.Configuration; 
using System.Collections; 
using System.Linq; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Web.UI.HtmlControls; 
using System.Xml.Linq; 
 
public partial  class LINQ_XLINQ_Sample : System.Web.UI.Page 
{ 
         protected  void Page_Load( object sender, EventArgs e) 
        { 
                 if (!Page.IsPostBack) 
                { 
                        BindPerson(); 
                } 
        } 
 
         private  void BindPerson() 
        { 
                 // 加载指定的xml文件 
                XDocument xml = XDocument.Load(Server.MapPath( "Sample.xml")); 
 
                 // 使用查询语法获取Person集合 
                var persons = from p  in xml.Root.Elements( "person") 
                                            select  new 
                                            { 
                                                    name = p.Attribute( "name").Value, 
                                                    age = p.Attribute( "age").Value, 
                                                    salary = p.Attribute( "salary").Value 
                                            }; 
 
                gvPerson.DataSource = persons; 
                gvPerson.DataBind(); 
        } 
 
         protected  void btnAdd_Click( object sender, EventArgs e) 
        { 
                 // 加载指定的xml文件 
                XDocument xml = XDocument.Load(Server.MapPath( "Sample.xml")); 
 
                 // 创建需要新增的XElement对象 
                XElement person =  new XElement( 
                         "person", 
                         new XAttribute( "name", txtName.Text), 
                         new XAttribute( "age", txtAge.Text), 
                         new XAttribute( "salary", txtSalary.Text)); 
 
                 // 添加需要新增的XElement对象 
                xml.Root.Add(person); 
                 
                 // 保存xml 
                xml.Save(Server.MapPath( "Sample.xml")); 
 
                gvPerson.EditIndex = -1; 
                BindPerson(); 
        } 
 
         protected  void gvPerson_SelectedIndexChanged( object sender, EventArgs e) 
        { 
                 // 加载指定的xml文件 
                XDocument xml = XDocument.Load(Server.MapPath( "Sample.xml")); 
 
                 // 使用查询语法获取指定的Person集合 
                var persons = from p  in xml.Root.Elements( "person") 
                                            where p.Attribute( "name").Value == gvPerson.SelectedValue.ToString() 
                                            select  new 
                                            { 
                                                    name = p.Attribute( "name").Value, 
                                                    age = p.Attribute( "age").Value, 
                                                    salary = p.Attribute( "salary").Value 
                                            }; 
 
                dvPerson.DataSource = persons; 
                dvPerson.DataBind(); 
        } 
 
         protected  void gvPerson_RowDeleting( object sender, GridViewDeleteEventArgs e) 
        { 
                 // 加载指定的xml文件 
                XDocument xml = XDocument.Load(Server.MapPath( "Sample.xml")); 
 
                 // 使用查询语法获取指定的Person集合 
                var persons = from p  in xml.Root.Elements( "person") 
                                            where p.Attribute( "name").Value == gvPerson.DataKeys[e.RowIndex].Value.ToString() 
                                            select p; 
 
                 // 删除指定的XElement对象 
                persons.Remove(); 
 
                 // 保存xml 
                xml.Save(Server.MapPath( "Sample.xml")); 
 
                gvPerson.EditIndex = -1; 
                BindPerson(); 
        } 
 
         protected  void gvPerson_RowUpdating( object sender, GridViewUpdateEventArgs e) 
        { 
                 // 加载指定的xml文件 
                XDocument xml = XDocument.Load(Server.MapPath( "Sample.xml")); 
 
                 // 使用查询语法获取指定的Person集合 
                var persons = from p  in xml.Root.Elements( "person") 
                                            where p.Attribute( "name").Value == gvPerson.DataKeys[e.RowIndex].Value.ToString() 
                                            select p; 
 
                 // 更新指定的XElement对象 
                 foreach (XElement xe  in persons) 
                { 
                        xe.SetAttributeValue( "age", ((TextBox)gvPerson.Rows[e.RowIndex].Cells[2].Controls[0]).Text); 
                        xe.SetAttributeValue( "salary", ((TextBox)gvPerson.Rows[e.RowIndex].Cells[3].Controls[0]).Text); 
                } 
 
                 // 保存xml 
                xml.Save(Server.MapPath( "Sample.xml")); 
 
                gvPerson.EditIndex = -1; 
                BindPerson(); 
        } 
 
         protected  void gvPerson_RowEditing( object sender, GridViewEditEventArgs e) 
        { 
                gvPerson.EditIndex = e.NewEditIndex; 
                BindPerson(); 
        } 
 
         protected  void gvPerson_RowCancelingEdit( object sender, GridViewCancelEditEventArgs e) 
        { 
                gvPerson.EditIndex = -1; 
                BindPerson(); 
        } 
}