C#读写XML

   最近领导要求我写一个工具建议我用Access做数据库，因为除了第一次需要从Excel中将数据导入到数据库中外就没有其他变动，所以我决定将Access数据库改为XML

在这里做个笔记以便以后查询

 

1、vo类中只有两个属性serial、evaluateItem

2、窗体中选择Excel文件，将所有数据放入List中（这里使用的是NExcel.dll）

 Workbook wb = Workbook.getWorkbook(filename); Sheet sheet = wb.getSheet(0); List<DataVO> list = new List<DataVO>(); for(int i = 3; i < sheet.Rows; i++){ if (!"".Equals(sheet.getCell(0, i).Contents)) { DataVO dvo = new DataVO(); dvo.setSerial(sheet.getCell(0, i).Contents); dvo.setEvaluateItem(sheet.getCell(1, i).Contents); list.Add(dvo); } } GenerateXML g = new GenerateXML(); g.generate(list);

3、下面是将List中的数据写到XML中

using System;using System.Collections.Generic;using System.Text;using System.Xml;namespace Computing.src{ class GenerateXML { public void generate(List<DataVO> list) { if (list.Count > 0) { DataVO dvo = (DataVO)list[0]; XmlDocument doc = new XmlDocument(); XmlNode sm = doc.CreateNode(XmlNodeType.XmlDeclaration, "", ""); doc.AppendChild(sm); XmlElement root = doc.CreateElement("root"); XmlElement item = doc.CreateElement("item"); XmlAttribute serial = doc.CreateAttribute("serial"); XmlAttribute evaluateItem = doc.CreateAttribute("evaluateItem"); serial.Value = dvo.getSerial(); evaluateItem.Value = dvo.getEvaluateItem(); item.Attributes.Append(serial); item.Attributes.Append(evaluateItem); generateSub(list, dvo.getSerial(), 1, item, doc); root.AppendChild(item); doc.AppendChild(root); doc.Save("test.xml"); } } public void generateSub(List<DataVO> list,String serial, int starIndex, XmlElement item, XmlDocument doc) { for (int i = starIndex; i < list.Count; i++) { DataVO dvo = (DataVO)list[i]; if (dvo.getSerial().StartsWith(serial) && (dvo.getSerial().Length - 2) == serial.Length) { XmlElement subItem = doc.CreateElement("item"); XmlAttribute serialAtt = doc.CreateAttribute("serial"); XmlAttribute evaluateItemAtt = doc.CreateAttribute("evaluateItem"); serialAtt.Value = dvo.getSerial(); evaluateItemAtt.Value = dvo.getEvaluateItem(); subItem.Attributes.Append(serialAtt); subItem.Attributes.Append(evaluateItemAtt); generateSub(list, dvo.getSerial(), i + 1, subItem, doc); item.AppendChild(subItem); } } } }}

4、读XML文件

XmlDocument doc = new XmlDocument();doc.Load("test.xml");GenerateTree g = new GenerateTree();g.generateRootNode(this.treeView1, doc);

5、读XML并生成树

using System;using System.Collections.Generic;using System.Text;using System.Xml;using System.Windows.Forms;namespace Computing.src{ class GenerateTree { public void generateRootNode(TreeView tree, XmlDocument doc) { XmlNode root = doc.DocumentElement.ChildNodes[0]; TreeNode rootNode = new TreeNode(); rootNode.Text = root.Attributes[1].Value; rootNode.ToolTipText = root.Attributes[0].Value; rootNode.Name = root.Attributes[0].Value; tree.Nodes.Add(rootNode); generateSubNode(rootNode, root); } public void generateSubNode(TreeNode node, XmlNode xmlNode) { int count = xmlNode.ChildNodes.Count; for (int i = 0; i < count; i++) { TreeNode subNode = new TreeNode(); subNode.Text = xmlNode.ChildNodes[i].Attributes[1].Value; subNode.Name = xmlNode.ChildNodes[i].Attributes[0].Value; subNode.ToolTipText = xmlNode.ChildNodes[i].Attributes[0].Value; node.Nodes.Add(subNode); generateSubNode(subNode, xmlNode.ChildNodes[i]); } } }}