数据库表内信息 表名为CP
1 public void CreateXmlFile() 2 { 3 using (ws1DataContext con = new ws1DataContext()) 4 { 5 6 XmlDocument xmlDoc = new XmlDocument(); 7 //创建类型声明节点 8 XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "utf-8", ""); 9 xmlDoc.AppendChild(node); 10 11 12 List<CP> clist = new List<CP>(); 13 clist = con.CP.ToList(); 14 int ii = clist.Count; 15 //创建根节点 16 XmlNode root = xmlDoc.CreateElement("User"); 17 18 xmlDoc.AppendChild(root); 19 for (int i = 0; i < ii; i++) 20 { 21 CreateNode(xmlDoc, root, "Ids", clist[i].Ids.ToString()); 22 CreateNode(xmlDoc, root, "Id", clist[i].ID.ToString()); 23 CreateNode(xmlDoc, root, "PC", clist[i].PJ.ToString()); 24 } 25 try 26 { 27 xmlDoc.Save("c://data2.xml"); 28 } 29 catch (Exception e) 30 { 31 //显示错误信息 32 Console.WriteLine(e.Message); 33 } 34 //Console.ReadLine(); 35 36 } 37 } 38 /// <summary> 39 /// 创建节点 40 /// </summary> 41 /// <param name="xmldoc"></param> xml文档 42 /// <param name="parentnode"></param>父节点 43 /// <param name="name"></param> 节点名 44 /// <param name="value"></param> 节点值 45 /// 46 public void CreateNode(XmlDocument xmlDoc, XmlNode parentNode, string name, string value) 47 { 48 XmlNode node = xmlDoc.CreateNode(XmlNodeType.Element, name, null); 49 node.InnerText = value; 50 parentNode.AppendChild(node); 51 }
导出的XML信息
![](https://i-blog.csdnimg.cn/blog_migrate/9050d1f92999df5597eda3433ae0253f.png)
无敌!