步步為營VS 2008 + .NET 3.5(14) - XLINQ(LINQ to XML)之針對XML檔案的添加、查詢、更新和删除

步步為營VS 2008 + .NET 3.5(14) - XLINQ(LINQ to XML)之針對XML檔案的添加、查詢、更新和删除

介紹

以某一XML檔案為例，XLINQ(LINQ to XML)之針對XML檔案的添加操作、查詢操作、更新操作和删除操作

示例

Sample.xml

<?xml version="1.0" encoding="utf-8"?> 

<root> 

    <person name="webabcd" age="27" salary="33" /> 

</root>

Sample.aspx

<%@ Page Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Sample.aspx.cs" 

        Inherits="LINQ_XLINQ_Sample" Title="針對XML檔案的添加、查詢、更新和删除" %> 

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server"> 

</asp:Content> 

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server"> 

        <p> 

                姓名：<asp:TextBox ID="txtName" runat="server"></asp:TextBox> 

                   年齡：<asp:TextBox ID="txtAge" runat="server"></asp:TextBox> 

                   薪水：<asp:TextBox ID="txtSalary" runat="server"></asp:TextBox> 

                <asp:Button ID="btnAdd" runat="server" Text="添加" OnClick="btnAdd_Click" /> 

        </p> 

        <asp:GridView ID="gvPerson" runat="server" DataKeyNames="name" OnSelectedIndexChanged="gvPerson_SelectedIndexChanged" 

                OnRowDeleting="gvPerson_RowDeleting" OnRowCancelingEdit="gvPerson_RowCancelingEdit" 

                OnRowEditing="gvPerson_RowEditing" OnRowUpdating="gvPerson_RowUpdating"> 

                <Columns> 

                        <asp:CommandField ShowSelectButton="True" ShowEditButton="True" ShowDeleteButton="True"> 

                        </asp:CommandField> 

                </Columns> 

        </asp:GridView> 

        <br /> 

        <asp:DetailsView ID="dvPerson" runat="server" DataKeyNames="name"> 

        </asp:DetailsView> 

</asp:Content>

Sample.aspx.cs

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) 

                // 建立需要新增的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) 

                // 使用查詢文法擷取指定的Person集合 

                                            where p.Attribute("name").Value == gvPerson.SelectedValue.ToString() 

                dvPerson.DataSource = persons; 

                dvPerson.DataBind(); 

        protected void gvPerson_RowDeleting(object sender, GridViewDeleteEventArgs e) 

                                            where p.Attribute("name").Value == gvPerson.DataKeys[e.RowIndex].Value.ToString() 

                                            select p; 

                // 删除指定的XElement對象 

                persons.Remove(); 

        protected void gvPerson_RowUpdating(object sender, GridViewUpdateEventArgs e) 

                // 更新指定的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); 

        protected void gvPerson_RowEditing(object sender, GridViewEditEventArgs e) 

                gvPerson.EditIndex = e.NewEditIndex; 

        protected void gvPerson_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) 

}

     本文轉自webabcd 51CTO部落格，原文連結：http://blog.51cto.com/webabcd/345020，如需轉載請自行聯系原作者