Linq操作XML实例源码，添加、删除、修改、查询功能已经实现

Linq操作XML实例源码，添加、删除、修改、查询功能已经实现

    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        static string strPath = "Employee.xml";
        static string strID = "";

        //窗体加载时加载XML文件
        private void Form1_Load(object sender, EventArgs e)
        {
            if (File.Exists(strPath))
            {
                groupBox1.Enabled = false;
                getXmlInfo();
            }
            else
                groupBox1.Enabled = true;
        }

        //创建XML文件
        private void button1_Click(object sender, EventArgs e)
        {
            XDocument doc = new XDocument(
                new XDeclaration("1.0", "utf-8", "yes"),
                new XElement(textBox1.Text,
                    new XElement(textBox2.Text, new XAttribute(textBox3.Text, textBox10.Text),
                        new XElement(textBox4.Text, textBox5.Text),
                        new XElement(textBox6.Text, textBox7.Text),
                        new XElement(textBox8.Text, textBox9.Text))
                    )
                );
            doc.Save(strPath);
            groupBox1.Enabled = false;
            getXmlInfo();
        }

        //添加XML元素
        private void button2_Click(object sender, EventArgs e)
        {
            XElement xe = XElement.Load(strPath);
            IEnumerable<XElement> elements1 = from element in xe.Elements("People")
                                              select element;
            //生成新的编号
            string str = (Convert.ToInt32(elements1.Max(element => element.Attribute("ID").Value))   1).ToString("000");
            XElement people = new XElement(
                "People", new XAttribute("ID", str),
                new XElement("Name", textBox11.Text),
                new XElement("Sex", comboBox1.Text),
                new XElement("Salary", textBox12.Text)
                );
            xe.Add(people);
            xe.Save(strPath);
            getXmlInfo();
        }

        //修改XML元素
        private void button3_Click(object sender, EventArgs e)
        {
            if (strID != "")
            {
                XElement xe = XElement.Load(strPath);
                IEnumerable<XElement> elements = from element in xe.Elements("People")
                                                 where element.Attribute("ID").Value == strID
                                                 select element;
                if (elements.Count() > 0)
                {
                    XElement newXE = elements.First();
                    newXE.SetAttributeValue("ID", strID);
                    newXE.ReplaceNodes(
                        new XElement("Name", textBox11.Text),
                        new XElement("Sex", comboBox1.Text),
                        new XElement("Salary", textBox12.Text)
                        );
                }
                xe.Save(strPath);
            } 
            getXmlInfo();
        }

        //删除XML元素
        private void button4_Click(object sender, EventArgs e)
        {
            if (strID != "")
            {
                XElement xe = XElement.Load(strPath);
                IEnumerable<XElement> elements = from element in xe.Elements("People")
                                                 where element.Attribute("ID").Value == strID
                                                 select element;
                if (elements.Count() > 0)
                    elements.First().Remove();
                xe.Save(strPath);
            }
            getXmlInfo();
        }

        //显示选中XML节点的详细信息
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            strID = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
            XElement xe = XElement.Load(strPath);
            IEnumerable<XElement> elements = from PInfo in xe.Elements("People")
                                             where PInfo.Attribute("ID").Value == strID
                                             select PInfo;
            foreach (XElement element in elements)
            {
                textBox11.Text = element.Element("Name").Value;
                comboBox1.SelectedItem = element.Element("Sex").Value;
                textBox12.Text = element.Element("Salary").Value;
            }
        }

        #region 将XML文件内容绑定到DataGridView控件
        /// <summary>
        /// 将XML文件内容绑定到DataGridView控件
        /// </summary>
        private void getXmlInfo()
        {
            DataSet myds = new DataSet();
            myds.ReadXml(strPath);
            dataGridView1.DataSource = myds.Tables[0];
        }
        #endregion
    }

<?xml version="1.0" encoding="utf-8"?>
<Peoples>
  <People ID="001">
    <Name>小王</Name>
    <Sex>男</Sex>
    <Salary>1500</Salary>
  </People>
</Peoples>

资源下载

此资源下载价格为2D币（VIP免费），请先登录

资源文件列表

Linq▓┘╫≈Xml/LinqOperXml.sln , 923
Linq▓┘╫≈Xml/LinqOperXml.suo , 13312
Linq▓┘╫≈Xml/LinqOperXml/bin/Debug/Employee.xml , 170
Linq▓┘╫≈Xml/LinqOperXml/bin/Debug/LinqOperXml.exe , 18944
Linq▓┘╫≈Xml/LinqOperXml/bin/Debug/LinqOperXml.pdb , 30208
Linq▓┘╫≈Xml/LinqOperXml/bin/Debug/LinqOperXml.vshost.exe , 14328
Linq▓┘╫≈Xml/LinqOperXml/bin/Debug/LinqOperXml.vshost.exe.manifest , 490
Linq▓┘╫≈Xml/LinqOperXml/Form1.cs , 5208
Linq▓┘╫≈Xml/LinqOperXml/Form1.Designer.cs , 20554
Linq▓┘╫≈Xml/LinqOperXml/Form1.resx , 5814
Linq▓┘╫≈Xml/LinqOperXml/LinqOperXml.csproj , 3768
Linq▓┘╫≈Xml/LinqOperXml/obj/Debug/LinqOperXml.csproj.FileListAbsolute.txt , 712
Linq▓┘╫≈Xml/LinqOperXml/obj/Debug/LinqOperXml.csproj.GenerateResource.Cache , 847
Linq▓┘╫≈Xml/LinqOperXml/obj/Debug/LinqOperXml.exe , 18944
Linq▓┘╫≈Xml/LinqOperXml/obj/Debug/LinqOperXml.Form1.resources , 180
Linq▓┘╫≈Xml/LinqOperXml/obj/Debug/LinqOperXml.pdb , 30208
Linq▓┘╫≈Xml/LinqOperXml/obj/Debug/LinqOperXml.Properties.Resources.resources , 180
Linq▓┘╫≈Xml/LinqOperXml/Program.cs , 492
Linq▓┘╫≈Xml/LinqOperXml/Properties/AssemblyInfo.cs , 1381
Linq▓┘╫≈Xml/LinqOperXml/Properties/Resources.Designer.cs , 2872
Linq▓┘╫≈Xml/LinqOperXml/Properties/Resources.resx , 5612
Linq▓┘╫≈Xml/LinqOperXml/Properties/Settings.Designer.cs , 1096
Linq▓┘╫≈Xml/LinqOperXml/Properties/Settings.settings , 249