已知有一个XML文件(bookstore.xml)如下:
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price>
</book>
</bookstore>
1、往<bookstore>节点中插入一个<book>节点:
XmlDocument xmlDoc=new XmlDocument();
xmlDoc.Load("bookstore.xml");
XmlNode root=xmlDoc.SelectSingleNode("bookstore");//查找<bookstore>
XmlElement xe1=xmlDoc.CreateElement("book");//创建一个<book>节点
xe1.SetAttribute("genre","李赞红");//设置该节点genre属性
xe1.SetAttribute("ISBN","2-3631-4");//设置该节点ISBN属性
XmlElement xesub1=xmlDoc.CreateElement("title");
xesub1.InnerText="CS从入门到精通";//设置文本节点
xe1.AppendChild(xesub1);//添加到<book>节点中
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);//添加到<bookstore>节点中
xmlDoc.Save("bookstore.xml");
//================
结果为:
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price>
</book>
<book genre="李赞红" ISBN="2-3631-4">
<title>CS从入门到精通</title>
<author>候捷</author>
<price>58.3</price>
</book>
</bookstore>
2、修改节点:将genre属性值为“李赞红“的节点的genre值改为“update李赞红”,将该节点的子节点<author>的文本修改为“亚胜”。
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");//保存。
//=================
最后结果为:
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price>
</book>
<book genre="update李赞红" ISBN="2-3631-4">
<title>CS从入门到精通</title>
<author>亚胜</author>
<price>58.3</price>
</book>
</bookstore>
3、删除 <book genre="fantasy" ISBN="2-3631-4">节点的genre属性,删除 <book genre="update李赞红" ISBN="2-3631-4">节点。
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");
//====================
最后结果为:
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price>
</book>
<book>
</book>
</bookstore>
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);//显示子节点点文本
}
}
C#操作xml代码
默认分类 2009-08-25 09:00:18 阅读21 评论0 字号:大中小
private DataSet GetDataSet()
{
DataSet ds = new DataSet();
DataTable dataTable = new DataTable( " Users " );
dataTable.Columns.Add( " item_url " );
dataTable.Columns.Add( " link " );
dataTable.Columns.Add( " itemtitle " );
try
{
XmlDocument doc = new XmlDocument();
doc.Load(Server.MapPath( " xmlpath " ));
if (doc == null )
{
return null ;
}
XmlNodeList nodeList = doc.SelectNodes( " /bcaster/item " );
foreach (XmlNode node in nodeList)
{
DataRow row = dataTable.NewRow();
row[ " item_url " ] = node.Attributes[ " item_url " ].Value;
row[ " link " ] = node.Attributes[ " link " ].Value;
row[ " itemtitle " ] = node.Attributes[ " itemtitle " ].Value;
dataTable.Rows.Add(row);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
ds.Tables.Add(dataTable);
return (ds);
}
// 修改xml中的节点
XmlDataDocument xmldoc = new XmlDataDocument();
xmldoc.Load(Server.MapPath( " xmlpaht " ));
int temp = e.Item.ItemIndex;
temp = temp + 1 ;
string id = temp.ToString();
XmlNodeList nodelist = xmldoc.SelectSingleNode( " bcaster " ).ChildNodes; // 获取item节点的所有子节点
foreach (XmlNode xn in nodelist)
{
XmlElement xe = (XmlElement)xn; // 将子节点类型转换为XmlElement类型
if (xe.GetAttribute( " id " ) == id)
{
xe.SetAttribute( " id " , id);
xe.SetAttribute( " item_url " ,((TextBox)e.Item.FindControl( " txtUrl " )).Text.Trim());
xe.SetAttribute( " link " , ((TextBox)e.Item.FindControl( " txtLink " )).Text.Trim());
xe.SetAttribute( " itemtitle " , ((TextBox)e.Item.FindControl( " txtTitle " )).Text.Trim());
}
}
xmldoc.Save(Server.MapPath( " xmlpath " ));
// 添加内容
XmlDataDocument xmldoc = new XmlDataDocument();
xmldoc.Load(Server.MapPath( " xmlpath " ));
XmlNode root = xmldoc.SelectSingleNode( " bcaster " ); // 查找<bcaster>
XmlElement xe1 = xmldoc.CreateElement( " item " ); // 创建一个<Node>节点
XmlNodeList nodelist = xmldoc.SelectNodes( " /bcaster/item " );
int count = nodelist.Count + 1 ;
string id = count.ToString();
xe1.SetAttribute( " id " ,id);
xe1.SetAttribute( " item_url " ,((TextBox)Panel1.FindControl( " txtUrl " )).Text.Trim());
xe1.SetAttribute( " link " , ((TextBox)Panel1.FindControl( " txtLink " )).Text.Trim());
xe1.SetAttribute( " itemtitle " , ((TextBox)Panel1.FindControl( " txtTitle " )).Text.Trim());
root.AppendChild(xe1);
xmldoc.Save(Server.MapPath( " xmlpath " ));
// 删除其中内容
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(Server.MapPath( " xmlpath " ));
XmlNode root = xmlDoc.SelectSingleNode( " bcaster " );
XmlNodeList xnl = xmlDoc.SelectSingleNode( " bcaster " ).ChildNodes;
int temp = e.Item.ItemIndex;
temp = temp + 1 ;
string id = temp.ToString();
for ( int i = 0 ; i < xnl.Count; i ++ )
{
XmlElement xe = (XmlElement)xnl.Item(i);
if (xe.GetAttribute( " id " ) == id)
{
root.RemoveChild(xe);
if (i < xnl.Count)
{
i = i - 1 ;
}
}
}
xmlDoc.Save(Server.MapPath( " xmlpath " ));