Home >Backend Development >XML/RSS Tutorial >C# code example for CURD operation on xml

C# code example for CURD operation on xml

Y2J
Y2JOriginal
2017-05-10 13:26:302067browse

This article mainly introduces C# examples of adding, deleting, modifying, and checking operations on XML. Please refer to it for reference.

It is known that there is an XML file (bookstore.xml) as follows:

The code is as follows :

<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon&#39;s Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price>
</book>
</bookstore>

1, Insert a 463aef0d2da08708f472268a99530dbe node into the 70520fc1addb88c1722487f5b44e82c9 node:

The code is as follows:

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");

The result is:

The code is as follows:

<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon&#39;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, Modify the node: Change the genre value of the node whose genre attribute value is "Li Zanhong" to "update" Li Zanhong", change the text of the child node 48fe722b397613e801e59f453d6c9330 of this node to "Ya Sheng".

The code is as follows:

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");//保存。

The final result is:

The code is as follows:

<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon&#39;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, Delete 07c3b58ff62fdeecb2675c7bcbb44317 the genre attribute of the node, delete the fbe74d918fd7b7010b5e0309b9ba575e node.

The code is as follows:

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");

The final result is:

The code is as follows:

<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book ISBN="2-3631-4">
<title>Oberon&#39;s Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price>
</book>
<book>
</book>
</bookstore>

4, Display all data

The code is as follows:

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);//显示子节点点文本}}

[Related recommendations]

1. XML Free Video Tutorial

2. Li Yanhui Xhtml video tutorial

3. XML technical manual

The above is the detailed content of C# code example for CURD operation on xml. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn