欢迎来到福编程网,本站提供各种互联网专业知识!

XML 增、删、改和查示例

发布时间:2007-03-07 作者: 来源:转载
1.已知有一个XML文件(bookstore.xml)如下:Oberon'sLegacyCorets,Eva5.951、往节点中插入一个节点:XmlDocumentxmlDoc=newXmlDocument();xmlDoc.Load("bookstore.xml");XmlNoderoot=xmlDoc.SelectSingleNode("bookstore");//查找XmlElementxe1=xmlDoc.

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





Oberon's Legacy
Corets, Eva
5.95


1、往节点中插入一个节点:


XmlDocument xmlDoc=new XmlDocument();
xmlDoc.Load("bookstore.xml");
XmlNode root=xmlDoc.SelectSingleNode("bookstore");//查找
XmlElement xe1=xmlDoc.CreateElement("book");//创建一个节点
xe1.SetAttribute("genre","李赞红");//设置该节点genre属性
xe1.SetAttribute("ISBN","2-3631-4");//设置该节点ISBN属性

XmlElement xesub1=xmlDoc.CreateElement("title");
xesub1.InnerText="CS从入门到精通";//设置文本节点
xe1.AppendChild(xesub1);//添加到节点中
XmlElement xesub2=xmlDoc.CreateElement("author");
xesub2.InnerText="候捷";
xe1.AppendChild(xesub2);
XmlElement xesub3=xmlDoc.CreateElement("price");
xesub3.InnerText="58.3";
xe1.AppendChild(xesub3);

root.AppendChild(xe1);//添加到节点中
xmlDoc.Save("bookstore.xml");


//================
结果为:





Oberon's Legacy
Corets, Eva
5.95


CS从入门到精通
候捷
58.3



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


XmlNodeList nodeList=xmlDoc.SelectSingleNode("bookstore").ChildNodes;//获取bookstore节点的所有子节点
foreach(XmlNode xn in nodeList)//遍历所有子节点
{
XmlElement xe=(XmlElement)xn;//将子节点类型转换为XmlElement类型
if(xe.GetAttribute("genre")=="李赞红")//如果genre属性值为“李赞红”
{
xe.SetAttribute("genre","update李赞红");//则修改该属性为“update李赞红”

XmlNodeList nls=xe.ChildNodes;//继续获取xe子节点的所有子节点
foreach(XmlNode xn1 in nls)//遍历
{
XmlElement xe2=(XmlElement)xn1;//转换类型
if(xe2.Name=="author")//如果找到
{
xe2.InnerText="亚胜";//则修改
break;//找到退出来就可以了
}
}
break;
}
}

xmlDoc.Save("bookstore.xml");//保存。

//=================

最后结果为:





Oberon's Legacy
Corets, Eva
5.95


CS从入门到精通
亚胜
58.3


3、删除 节点的genre属性,删除 节点。


XmlNodeList xnl=xmlDoc.SelectSingleNode("bookstore").ChildNodes;

foreach(XmlNode xn in xnl)
{
XmlElement xe=(XmlElement)xn;




if(xe.GetAttribute("genre")=="fantasy")
{
xe.RemoveAttribute("genre");//删除genre属性
}
else if(xe.GetAttribute("genre")=="update李赞红")
{
xe.RemoveAll();//删除该节点的全部内容
}
}
xmlDoc.Save("bookstore.xml");


//====================

最后结果为:





Oberon's Legacy
Corets, Eva
5.95




4、显示所有数据。


XmlNode xn=xmlDoc.SelectSingleNode("bookstore");

XmlNodeList xnl=xn.ChildNodes;

foreach(XmlNode xnf in xnl)
{
XmlElement xe=(XmlElement)xnf;
Console.WriteLine(xe.GetAttribute("genre"));//显示属性值
Console.WriteLine(xe.GetAttribute("ISBN"));

XmlNodeList xnf1=xe.ChildNodes;
foreach(XmlNode xn2 in xnf1)
{
Console.WriteLine(xn2.InnerText);//显示子节点点文本
}
}


留做参考,原文地址http://blog.yesky.com/75/richsee/1211075.shtml

2前台代码:html

<%@Pagelanguage="c#"Codebehind="Main.aspx.cs"AutoEventWireup="false"Inherits="DsAndXML.OpXMLFile.Main"%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.0Transitional//EN">
<HTML>
<HEAD>
<title>Maintitle>
<metaname="GENERATOR"Content="MicrosoftVisualStudio7.0">
<metaname="CODE_LANGUAGE"Content="C#">
<metaname="vs_defaultClientScript"content="JavaScript">
<metaname="vs_targetSchema"content="http://schemas.microsoft.com/intellisense/ie5">
HEAD>
<bodyMS_POSITIONING="GridLayout">
<formid="Main"method="post"runat="server">
<FONTface="宋体">
<asp:DataGridid="dgShow"style="Z-INDEX:100;LEFT:113px;POSITION:absolute;TOP:32px"runat="server"Width="480px"Height="178px">asp:DataGrid>
<asp:Labelid="Label3"style="Z-INDEX:111;LEFT:187px;POSITION:absolute;TOP:383px"runat="server"Width="120px"Height="21px">新邮件地址:asp:Label>
<asp:Labelid="Label2"style="Z-INDEX:107;LEFT:333px;POSITION:absolute;TOP:274px"runat="server"Width="83px"Height="21px">邮件地址:asp:Label>
<asp:Buttonid="btnAdd"style="Z-INDEX:104;LEFT:298px;POSITION:absolute;TOP:324px"runat="server"Text="添加">asp:Button>
<asp:Buttonid="btnDelete"style="Z-INDEX:103;LEFT:199px;POSITION:absolute;TOP:324px"runat="server"Text="删除">asp:Button>
<asp:Buttonid="btnChange"style="Z-INDEX:102;LEFT:102px;POSITION:absolute;TOP:382px"runat="server"Text="修改">asp:Button>
<asp:Buttonid="btnQuery"style="Z-INDEX:101;LEFT:101px;POSITION:absolute;TOP:324px"runat="server"Text="查询">asp:Button>
<asp:DropDownListid="ddlName"style="Z-INDEX:105;LEFT:210px;POSITION:absolute;TOP:274px"runat="server"Width="95px"Height="78px">asp:DropDownList>
<asp:Labelid="Label1"style="Z-INDEX:106;LEFT:100px;POSITION:absolute;TOP:274px"runat="server"Width="83px"Height="21px">姓名:asp:Label>
<asp:Labelid="lbEmail"style="Z-INDEX:109;LEFT:459px;POSITION:absolute;TOP:274px"runat="server"Width="231px">asp:Label>
<asp:TextBoxid="tbNewMail"style="Z-INDEX:110;LEFT:330px;POSITION:absolute;TOP:381px"runat="server"Width="208px"Height="26px">asp:TextBox>FONT>
form>
body>
HTML>XML文件dbGuest.xml
xmlversion="1.0"standalone="yes"?>
<dbGuest>
<User>
<Name>aaaName>
<City>shanghaiCity>
<Email>aaa@263.netEmail>
<Message>okMessage>
<STime>2004-07-12T00:00:00.0000000+08:00STime>
User>
<User>
<Name>shaoazhdName>
<City>beijingCity>
<Email>sss@22.netEmail>
<Message>afsaMessage>
<STime>2004-7-1215:07:39STime>
User>
<User>
<Name>GusetName>
<City>上海City>
<Email>sfaf@22.netEmail>
User>
<User>
<Name>GusetName>
<City>上海City>
<Email>ss@22.netEmail>
User>
dbGuest> usingSystem;
usingSystem.Collections;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Web;
usingSystem.Web.SessionState;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.HtmlControls;
usingSystem.Xml;
usingSystem.Xml.XPath;
namespaceDsAndXML.OpXMLFile
{
///
///Main的摘要说明。
///

publicclassMain:System.Web.UI.Page
{
protectedSystem.Web.UI.WebControls.ButtonbtnQuery;
protectedSystem.Web.UI.WebControls.ButtonbtnChange;
protectedSystem.Web.UI.WebControls.ButtonbtnDelete;
protectedSystem.Web.UI.WebControls.ButtonbtnAdd;
protectedSystem.Web.UI.WebControls.DropDownListddlName;
protectedSystem.Web.UI.WebControls.LabelLabel1;
protectedSystem.Web.UI.WebControls.LabelLabel2;
protectedSystem.Web.UI.WebControls.LabellbEmail;
protectedSystem.Web.UI.WebControls.TextBoxtbNewMail;
protectedSystem.Web.UI.WebControls.LabelLabel3;
protectedSystem.Web.UI.WebControls.DataGriddgShow;

privatevoidPage_Load(objectsender,System.EventArgse)
{
//在此处放置用户代码以初始化页面
if(!IsPostBack)
Bind();

}

privatevoidBind()
{
DataSetds
=newDataSet();
ds.ReadXml(Server.MapPath(
".dbdbGuest.xml"));
dgShow.DataSource
=ds.Tables[0].DefaultView;
dgShow.DataBind();
XmlDocumentdoc
=newXmlDocument();
doc.Load(Server.MapPath(
".dbdbGuest.xml"));
XmlNodeListelemList
=doc.GetElementsByTagName("Name");
ddlName.Items.Clear();
for(inti=0;i<elemList.Count;i++)
ddlName.Items.Add(elemList[i].InnerXml);

}


WebFormDesignergeneratedcode

privatevoidbtnQuery_Click(objectsender,System.EventArgse)
{
XmlDocumentdoc
=newXmlDocument();
doc.Load(Server.MapPath(
".dbdbGuest.xml"));
lbEmail.Text
=doc.SelectSingleNode("//User[Name='"+ddlName.SelectedItem.Text+"']").ChildNodes.Item(2).InnerText;

}


privatevoidbtnChange_Click(objectsender,System.EventArgse)
{
XmlDocumentxmlDoc
=newXmlDocument();
xmlDoc.Load(Server.MapPath(
".dbdbGuest.xml"));
XmlNodeListnodeList
=xmlDoc.SelectSingleNode("dbGuest").ChildNodes;//获取dbGuest节点的所有子节点
foreach(XmlNodexninnodeList)//遍历所有子节点
{
XmlElementxe
=(XmlElement)xn;//将子节点类型转换为XmlElement类型

XmlNodeListnode
=xe.GetElementsByTagName("Name");
if(node.Count>0)
{

if(node[0].InnerText==

相关推荐