在C#中操作XML

来源:互联网 发布:淘宝三国杀主播店 编辑:程序博客网 时间:2024/05/18 01:51

 已知有一个XML文件(bookstore.xml)如下:

  1. <?xml version="1.0" encoding="gb2312"?>
  2. <bookstore>
  3.   <book genre="fantasy" ISBN="2-3631-4">
  4.     <title>Oberon's Legacy</title>
  5.     <author>Corets, Eva</author>
  6.     <price>5.95</price>
  7.   </book>
  8. </bookstore>

1、往<bookstore>节点中插入一个<book>节点:

  1.  XmlDocument xmlDoc=new XmlDocument();
  2.    xmlDoc.Load("bookstore.xml");
  3.    XmlNode root=xmlDoc.SelectSingleNode("bookstore");//查找<bookstore>
  4.    XmlElement xe1=xmlDoc.CreateElement("book");//创建一个<book>节点
  5.    xe1.SetAttribute("genre","李赞红");//设置该节点genre属性
  6.    xe1.SetAttribute("ISBN","2-3631-4");//设置该节点ISBN属性
  7.    XmlElement xesub1=xmlDoc.CreateElement("title");
  8.    xesub1.InnerText="CS从入门到精通";//设置文本节点
  9.    xe1.AppendChild(xesub1);//添加到<book>节点中
  10.    XmlElement xesub2=xmlDoc.CreateElement("author");
  11.    xesub2.InnerText="候捷";
  12.    xe1.AppendChild(xesub2);
  13.    XmlElement xesub3=xmlDoc.CreateElement("price");
  14.    xesub3.InnerText="58.3";
  15.    xe1.AppendChild(xesub3);
  16.    root.AppendChild(xe1);//添加到<bookstore>节点中
  17.    xmlDoc.Save("bookstore.xml");
//===============================================
结果为:
  1. <?xml version="1.0" encoding="gb2312"?>
  2. <bookstore>
  3.   <book genre="fantasy" ISBN="2-3631-4">
  4.     <title>Oberon's Legacy</title>
  5.     <author>Corets, Eva</author>
  6.     <price>5.95</price>
  7.   </book>
  8.   <book genre="李赞红" ISBN="2-3631-4">
  9.     <title>CS从入门到精通</title>
  10.     <author>候捷</author>
  11.     <price>58.3</price>
  12.   </book>
  13. </bookstore>

2、修改节点:将genre属性值为“李赞红“的节点的genre值改为“update李赞红”,将该节点的子节点<author>的文本修改为“亚胜”。

  1.   XmlNodeList nodeList=xmlDoc.SelectSingleNode("bookstore").ChildNodes;//获取bookstore节点的所有子节点
  2.    foreach(XmlNode xn in nodeList)//遍历所有子节点
  3.    {
  4.     XmlElement xe=(XmlElement)xn;//将子节点类型转换为XmlElement类型
  5.     if(xe.GetAttribute("genre")=="李赞红")//如果genre属性值为“李赞红”
  6.     {
  7.      xe.SetAttribute("genre","update李赞红");//则修改该属性为“update李赞红”
  8.      XmlNodeList nls=xe.ChildNodes;//继续获取xe子节点的所有子节点
  9.      foreach(XmlNode xn1 in nls)//遍历
  10.      {
  11.       XmlElement xe2=(XmlElement)xn1;//转换类型
  12.       if(xe2.Name=="author")//如果找到
  13.       {
  14.        xe2.InnerText="亚胜";//则修改
  15.        break;//找到退出来就可以了
  16.       }
  17.      }
  18.      break;
  19.     }
  20.    }
  21.    xmlDoc.Save("bookstore.xml");//保存。
//==================================================
最后结果为:
  1. <?xml version="1.0" encoding="gb2312"?>
  2. <bookstore>
  3.   <book genre="fantasy" ISBN="2-3631-4">
  4.     <title>Oberon's Legacy</title>
  5.     <author>Corets, Eva</author>
  6.     <price>5.95</price>
  7.   </book>
  8.   <book genre="update李赞红" ISBN="2-3631-4">
  9.     <title>CS从入门到精通</title>
  10.     <author>亚胜</author>
  11.     <price>58.3</price>
  12.   </book>
  13. </bookstore>

3、删除 <book genre="fantasy" ISBN="2-3631-4">节点的genre属性,删除 <book genre="update李赞红" ISBN="2-3631-4">节点。

  1. XmlNodeList xnl=xmlDoc.SelectSingleNode("bookstore").ChildNodes;
  2.    foreach(XmlNode xn in xnl)
  3.    {
  4.     XmlElement xe=(XmlElement)xn;
  5.     if(xe.GetAttribute("genre")=="fantasy")
  6.     {
  7.      xe.RemoveAttribute("genre");//删除genre属性
  8.     }
  9.     else if(xe.GetAttribute("genre")=="update李赞红")
  10.     {
  11.      xe.RemoveAll();//删除该节点的全部内容
  12.     }
  13.    }
  14.    xmlDoc.Save("bookstore.xml");

//===========================================
最后结果为:

  1. <?xml version="1.0" encoding="gb2312"?>
  2. <bookstore>
  3.   <book ISBN="2-3631-4">
  4.     <title>Oberon's Legacy</title>
  5.     <author>Corets, Eva</author>
  6.     <price>5.95</price>
  7.   </book>
  8.   <book>
  9.   </book>
  10. </bookstore>

4、显示所有数据。

  1. XmlNode xn=xmlDoc.SelectSingleNode("bookstore");
  2.    XmlNodeList xnl=xn.ChildNodes;
  3.    
  4.    foreach(XmlNode xnf in xnl)
  5.    {
  6.     XmlElement xe=(XmlElement)xnf;
  7.     Console.WriteLine(xe.GetAttribute("genre"));//显示属性值
  8.     Console.WriteLine(xe.GetAttribute("ISBN"));
  9.     XmlNodeList xnf1=xe.ChildNodes;
  10.     foreach(XmlNode xn2 in xnf1)
  11.     {
  12.      Console.WriteLine(xn2.InnerText);//显示子节点点文本
  13.     }
  14.    }

前台代码:html

  1. <%@ Page language="c#" Codebehind="Main.aspx.cs" AutoEventWireup="false" Inherits="DsAndXML.OpXMLFile.Main" %>
  2. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
  3. <HTML>
  4.     <HEAD>
  5.         <title>Main</title>
  6.         <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
  7.         <meta name="CODE_LANGUAGE" Content="C#">
  8.         <meta name="vs_defaultClientScript" content="JavaScript">
  9.         <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
  10.     </HEAD>
  11.     <body MS_POSITIONING="GridLayout">
  12.         <form id="Main" method="post" runat="server">
  13.             <FONT face="宋体">
  14.                 <asp:DataGrid id="dgShow" style="Z-INDEX: 100; LEFT: 113px; POSITION: absolute; TOP: 32px" runat="server" Width="480px" Height="178px"></asp:DataGrid>
  15.                 <asp:Label id="Label3" style="Z-INDEX: 111; LEFT: 187px; POSITION: absolute; TOP: 383px" runat="server" Width="120px" Height="21px">新邮件地址:</asp:Label>
  16.                 <asp:Label id="Label2" style="Z-INDEX: 107; LEFT: 333px; POSITION: absolute; TOP: 274px" runat="server" Width="83px" Height="21px">邮件地址:</asp:Label>
  17.                 <asp:Button id="btnAdd" style="Z-INDEX: 104; LEFT: 298px; POSITION: absolute; TOP: 324px" runat="server" Text="添加"></asp:Button>
  18.                 <asp:Button id="btnDelete" style="Z-INDEX: 103; LEFT: 199px; POSITION: absolute; TOP: 324px" runat="server" Text="删除"></asp:Button>
  19.                 <asp:Button id="btnChange" style="Z-INDEX: 102; LEFT: 102px; POSITION: absolute; TOP: 382px" runat="server" Text="修改"></asp:Button>
  20.                 <asp:Button id="btnQuery" style="Z-INDEX: 101; LEFT: 101px; POSITION: absolute; TOP: 324px" runat="server" Text="查询"></asp:Button>
  21.                 <asp:DropDownList id="ddlName" style="Z-INDEX: 105; LEFT: 210px; POSITION: absolute; TOP: 274px" runat="server" Width="95px" Height="78px"></asp:DropDownList>
  22.                 <asp:Label id="Label1" style="Z-INDEX: 106; LEFT: 100px; POSITION: absolute; TOP: 274px" runat="server" Width="83px" Height="21px">姓名:</asp:Label>
  23.                 <asp:Label id="lbEmail" style="Z-INDEX: 109; LEFT: 459px; POSITION: absolute; TOP: 274px" runat="server" Width="231px"></asp:Label>
  24.                 <asp:TextBox id="tbNewMail" style="Z-INDEX: 110; LEFT: 330px; POSITION: absolute; TOP: 381px" runat="server" Width="208px" Height="26px"></asp:TextBox></FONT>
  25.         </form>
  26.     </body>
  27. </HTML>XML文件dbGuest.xml
  28. <?xml version="1.0" standalone="yes"?>
  29. <dbGuest>
  30.   <User>
  31.     <Name>aaa</Name>
  32.     <City>shanghai</City>
  33.     <Email>aaa@263.net</Email>
  34.     <Message>ok</Message>
  35.     <STime>2004-07-12T00:00:00.0000000+08:00</STime>
  36.   </User>
  37.   <User>
  38.     <Name>shaoazhd</Name>
  39.     <City>beijing</City>
  40.     <Email>sss@22.net</Email>
  41.     <Message>afsa</Message>
  42.     <STime>2004-7-12 15:07:39</STime>
  43.   </User>
  44.   <User>
  45.     <Name>Guset</Name>
  46.     <City>上海</City>
  47.     <Email>sfaf@22.net</Email>
  48.   </User>
  49.   <User>
  50.     <Name>Guset</Name>
  51.     <City>上海</City>
  52.     <Email>ss@22.net</Email>
  53.   </User>
  54. </dbGuest>

XML文件dbGuest.xml

  1. <?xml version="1.0" standalone="yes"?>
  2. <dbGuest>
  3.   <User>
  4.     <Name>aaa</Name>
  5.     <City>shanghai</City>
  6.     <Email>aaa@263.net</Email>
  7.     <Message>ok</Message>
  8.     <STime>2004-07-12T00:00:00.0000000+08:00</STime>
  9.   </User>
  10.   <User>
  11.     <Name>shaoazhd</Name>
  12.     <City>beijing</City>
  13.     <Email>sss@22.net</Email>
  14.     <Message>afsa</Message>
  15.     <STime>2004-7-12 15:07:39</STime>
  16.   </User>
  17.   <User>
  18.     <Name>Guset</Name>
  19.     <City>上海</City>
  20.     <Email>sfaf@22.net</Email>
  21.   </User>
  22.   <User>
  23.     <Name>Guset</Name>
  24.     <City>上海</City>
  25.     <Email>ss@22.net</Email>
  26.   </User>
  27. </dbGuest>
  1. using System;
  2. using System.Collections;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Web;
  7. using System.Web.SessionState;
  8. using System.Web.UI;
  9. using System.Web.UI.WebControls;
  10. using System.Web.UI.HtmlControls;
  11. using System.Xml;
  12. using System.Xml.XPath;
  13. namespace DsAndXML.OpXMLFile
  14. {
  15.     /**//**//**//// <summary>
  16.     /// Main 的摘要说明。
  17.     /// </summary>
  18.     public class Main : System.Web.UI.Page
  19.     {
  20.         protected System.Web.UI.WebControls.Button btnQuery;
  21.         protected System.Web.UI.WebControls.Button btnChange;
  22.         protected System.Web.UI.WebControls.Button btnDelete;
  23.         protected System.Web.UI.WebControls.Button btnAdd;
  24.         protected System.Web.UI.WebControls.DropDownList ddlName;
  25.         protected System.Web.UI.WebControls.Label Label1;
  26.         protected System.Web.UI.WebControls.Label Label2;
  27.         protected System.Web.UI.WebControls.Label lbEmail;
  28.         protected System.Web.UI.WebControls.TextBox tbNewMail;
  29.         protected System.Web.UI.WebControls.Label Label3;
  30.         protected System.Web.UI.WebControls.DataGrid dgShow;
  31.     
  32.         private void Page_Load(object sender, System.EventArgs e)
  33.         {
  34.             // 在此处放置用户代码以初始化页面
  35.             if(!IsPostBack)
  36.             Bind();
  37.         }
  38.         private void Bind()
  39.         {
  40.             DataSet ds = new DataSet();
  41.             ds.ReadXml(Server.MapPath(".//db//dbGuest.xml"));
  42.             dgShow.DataSource = ds.Tables[0].DefaultView;
  43.             dgShow.DataBind();
  44.             XmlDocument doc = new XmlDocument();
  45.             doc.Load(Server.MapPath(".//db//dbGuest.xml"));
  46.             XmlNodeList elemList = doc.GetElementsByTagName("Name");
  47.             ddlName.Items.Clear();
  48.             for(int i=0;i<elemList.Count;i++)
  49.              ddlName.Items.Add(elemList[i].InnerXml);
  50.             
  51.         }
  52.         Web Form Designer generated codeWeb Form Designer generated code#region Web Form Designer generated code
  53.         override protected void OnInit(EventArgs e)
  54.         {
  55.             //
  56.             // CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
  57.             //
  58.             InitializeComponent();
  59.             base.OnInit(e);
  60.         }
  61.         
  62.         /**//**//**//// <summary>
  63.         /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  64.         /// 此方法的内容。
  65.         /// </summary>
  66.         private void InitializeComponent()
  67.         {    
  68.             this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
  69.             this.btnChange.Click += new System.EventHandler(this.btnChange_Click);
  70.             this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
  71.             this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
  72.             this.Load += new System.EventHandler(this.Page_Load);
  73.         }
  74.         #endregion
  75.         private void btnQuery_Click(object sender, System.EventArgs e)
  76.         {
  77.             XmlDocument doc = new XmlDocument();
  78.             doc.Load(Server.MapPath(".//db//dbGuest.xml"));
  79.             lbEmail.Text = doc.SelectSingleNode("//User[Name='"+ddlName.SelectedItem.Text+"']").ChildNodes.Item(2).InnerText;
  80.          
  81.         }
  82.         private void btnChange_Click(object sender, System.EventArgs e)
  83.         {
  84.             XmlDocument xmlDoc = new XmlDocument();
  85.             xmlDoc.Load(Server.MapPath(".//db//dbGuest.xml"));
  86.             XmlNodeList nodeList=xmlDoc.SelectSingleNode("dbGuest").ChildNodes;//获取dbGuest节点的所有子节点
  87.             foreach(XmlNode xn in nodeList)//遍历所有子节点
  88.             {
  89.                 XmlElement xe=(XmlElement)xn;//将子节点类型转换为XmlElement类型
  90.             
  91.                 XmlNodeList node = xe.GetElementsByTagName("Name");
  92.                 if(node.Count>0)
  93.                 {
  94.                     if(node[0].InnerText==ddlName.SelectedItem.Text)
  95.                     {
  96.                         XmlNodeList nls=xe.ChildNodes;//继续获取xe子节点的所有子节点
  97.                         foreach(XmlNode xn1 in nls)//遍历
  98.                         {
  99.                             XmlElement xe2=(XmlElement)xn1;//转换类型
  100.                             if(xe2.Name=="Email")//如果找到
  101.                             {
  102.                                 xe2.InnerText=tbNewMail.Text;//则修改
  103.                                 break;//找到退出来就可以了
  104.                             }
  105.                         }
  106.                         break;
  107.                     }
  108.                 }
  109.                 
  110.             }
  111.             xmlDoc.Save(Server.MapPath(".//db//dbGuest.xml"));
  112.             Bind();
  113.         }
  114.         private void btnDelete_Click(object sender, System.EventArgs e)
  115.         {
  116.             XmlDocument xmlDoc = new XmlDocument();
  117.             xmlDoc.Load(Server.MapPath(".//db//dbGuest.xml"));
  118.             XmlNodeList xnl=xmlDoc.SelectSingleNode("dbGuest").ChildNodes;
  119.             foreach(XmlNode xn in xnl)
  120.             {
  121.                 XmlElement xe=(XmlElement)xn;
  122.                 XmlNodeList node = xe.GetElementsByTagName("Name");
  123.                 if(node.Count>0)
  124.                 {
  125.                     if(node[0].InnerText==ddlName.SelectedItem.Text)
  126.                         xe.RemoveAll();//删除该节点的全部内容
  127.                     break;
  128.                 }
  129.             }
  130.             
  131.             xmlDoc.Save(Server.MapPath(".//db//dbGuest.xml"));
  132.             Bind();
  133.         }
  134.         private void btnAdd_Click(object sender, System.EventArgs e)
  135.         {
  136.             XmlDocument xmlDoc = new XmlDocument();
  137.             xmlDoc.Load(Server.MapPath(".//db//dbGuest.xml"));
  138.             XmlNode root=xmlDoc.SelectSingleNode("dbGuest");//查找<dbGuest>
  139.             XmlElement xe1=xmlDoc.CreateElement("User");//创建一个<User>节点
  140.             XmlElement xesub1=xmlDoc.CreateElement("Name");
  141.             xesub1.InnerText="Guset";//设置文本节点
  142.             xe1.AppendChild(xesub1);//添加到<User>节点中
  143.             XmlElement xesub2=xmlDoc.CreateElement("City");
  144.             xesub2.InnerText="上海";
  145.             xe1.AppendChild(xesub2);
  146.             XmlElement xesub3=xmlDoc.CreateElement("Email");
  147.             xesub3.InnerText="ss@22.net";
  148.             xe1.AppendChild(xesub3);
  149.             root.AppendChild(xe1);//添加到<dbGuest>节点中
  150.             xmlDoc.Save(Server.MapPath(".//db//dbGuest.xml"));
  151.             Bind();
  152.         }
  153.     }
  154. }
原创粉丝点击