1 using System.Xml;
2 using System.Xml.Serialization;
3 /// <summary>
4 /// 下面两个方法实现xml文件和datatable间的相互转换
5 /// </summary>
6 /// <param name="strXml"></param>
7 /// <returns></returns>
8 public StringBuilder datatableToXml(DataTable dt) //返回stringbuilder类型
9 {
10 StringBuilder stb = new StringBuilder();
11 XmlSerializer serializer = new XmlSerializer(typeof(DataTable));
12 XmlWriter writer = XmlWriter.Create(stb);
13 serializer.Serialize(writer, dt);
14 writer.Close();
15 return stb;
16 }
17
18 public DataTable xmlToDatatable(string strXml) //返回datatable类型
19 {
20 StringReader sr = new StringReader(strXml);
21 XmlTextReader xtr = new XmlTextReader(sr);
22 DataTable dt = new DataTable();
23 dt.ReadXml(xtr);
24 sr.Close();
25 xtr.Close();
26 return dt;
27 }