XML与DataSet的相互转换

XmlDatasetConvert 该类提供了四种方法：
1、将xml对象内容字符串转换为DataSet
2、将xml文件转换为DataSet
3、将DataSet转换为xml对象字符串
4、将DataSet转换为xml文件

  1 //XmlDatasetConvert.cs
  2 
  3 using System;
  4 using System.Collections.Generic;
  5 using System.Text;
  6 using System.Data;
  7 using System.IO;
  8 using System.Xml;
  9 
 10 namespace XmlDesign
 11 {
 12     class XmlDatasetConvert
 13     {
 14         //将xml对象内容字符串转换为DataSet
 15         public static DataSet ConvertXMLToDataSet(string xmlData)
 16         {
 17             StringReader stream = null;
 18             XmlTextReader reader = null;
 19             try
 20             {
 21                 DataSet xmlDS = new DataSet();
 22                 stream = new StringReader(xmlData);
 23                 //从stream装载到XmlTextReader
 24                 reader = new XmlTextReader(stream);
 25                 xmlDS.ReadXml(reader);
 26                 return xmlDS;
 27             }
 28             catch (System.Exception ex)
 29             {
 30                 throw ex;
 31             }
 32             finally
 33             {
 34                 if (reader != null) reader.Close();
 35             }
 36         }
 37 
 38         //将xml文件转换为DataSet
 39         public static DataSet ConvertXMLFileToDataSet(string xmlFile)
 40         {
 41             StringReader stream = null;
 42             XmlTextReader reader = null;
 43             try
 44             {
 45                 XmlDocument xmld = new XmlDocument();
 46                 xmld.Load(xmlFile);
 47 
 48                 DataSet xmlDS = new DataSet();
 49                 stream = new StringReader(xmld.InnerXml);
 50                 //从stream装载到XmlTextReader
 51                 reader = new XmlTextReader(stream);
 52                 xmlDS.ReadXml(reader);
 53                 //xmlDS.ReadXml(xmlFile);
 54                 return xmlDS;
 55             }
 56             catch (System.Exception ex)
 57             {
 58                 throw ex;
 59             }
 60             finally
 61             {
 62                 if (reader != null) reader.Close();
 63             }
 64         }
 65 
 66         //将DataSet转换为xml对象字符串
 67         public static string ConvertDataSetToXML(DataSet xmlDS)
 68         {
 69             MemoryStream stream = null;
 70             XmlTextWriter writer = null;
 71 
 72             try
 73             {
 74                 stream = new MemoryStream();
 75                 //从stream装载到XmlTextReader
 76                 writer = new XmlTextWriter(stream, Encoding.Unicode);
 77 
 78                 //用WriteXml方法写入文件.
 79                 xmlDS.WriteXml(writer);
 80                 int count = (int)stream.Length;
 81                 byte[] arr = new byte[count];
 82                 stream.Seek(0, SeekOrigin.Begin);
 83                 stream.Read(arr, 0, count);
 84 
 85                 UnicodeEncoding utf = new UnicodeEncoding();
 86                 return utf.GetString(arr).Trim();
 87             }
 88             catch (System.Exception ex)
 89             {
 90                 throw ex;
 91             }
 92             finally
 93             {
 94                 if (writer != null) writer.Close();
 95             }
 96         }
 97 
 98         //将DataSet转换为xml文件
 99         public static void ConvertDataSetToXMLFile(DataSet xmlDS,string xmlFile)
100         {
101             MemoryStream stream = null;
102             XmlTextWriter writer = null;
103 
104             try
105             {
106                 stream = new MemoryStream();
107                 //从stream装载到XmlTextReader
108                 writer = new XmlTextWriter(stream, Encoding.Unicode);
109 
110                 //用WriteXml方法写入文件.
111                 xmlDS.WriteXml(writer);
112                 int count = (int)stream.Length;
113                 byte[] arr = new byte[count];
114                 stream.Seek(0, SeekOrigin.Begin);
115                 stream.Read(arr, 0, count);
116 
117                 //返回Unicode编码的文本
118                 UnicodeEncoding utf = new UnicodeEncoding();
119                 StreamWriter sw = new StreamWriter(xmlFile);
120                 sw.WriteLine("<?xml version="1.0" encoding="utf-8"?>");
121                 sw.WriteLine(utf.GetString(arr).Trim());
122                 sw.Close();
123             }
124             catch( System.Exception ex )
125             {
126                 throw ex;
127             }
128             finally
129             {
130                 if (writer != null) writer.Close();
131             }
132         }
133 
134     }
135 }
136 //使用示例
137 
138 using System;
139 using System.Collections.Generic;
140 using System.Text;
141 using System.Xml;
142 using System.Data;
143 
144 namespace XmlDesign
145 {
146     class Program
147     {
148         static void Main(string[] args)
149         {
150             DataSet ds = new DataSet();
151 
152             //转换一个XML文件(本地网络均可)为一个DataSet
153             #region 转换一个XML文件(本地网络均可)为一个DataSet
154             //http://news.baidu.com/n?cmd=1&class=sportnews&tn=rss
155             //F:study01CSharp_Study02SourceXmlDesignXmlDesignSave_Plan.xml
156             ds = XmlDatasetConvert.ConvertXMLFileToDataSet(@"c:\adadsda1.xml");
157             Console.WriteLine("数据集名为"{0}",包含{1}个表", ds.DataSetName, ds.Tables.Count);
158             foreach(DataTable dt in ds.Tables)
159             {
160                 PrintTableName(dt.TableName);
161             };
162             #endregion
163 
164             //构造一个DataSet,并转换为XML字符串
165             #region 构造一个DataSet,并转换为XML字符串
166             DataSet ds1 = new DataSet();
167             DataTable dt1 = new DataTable();
168             dt1.TableName = "test";
169             dt1.Columns.Add("id");
170             dt1.Columns.Add("name");
171             dt1.Rows.Add("i001", "hekui");
172             dt1.Rows.Add("i002", "liyang");
173 
174             DataTable dt2 = new DataTable();
175             dt2.TableName = "test1";
176             dt2.Columns.Add("bookid");
177             dt2.Columns.Add("bookname");
178             dt2.Rows.Add("b001", "书本1");
179             dt2.Rows.Add("b002", "书本2");
180 
181             ds1.Tables.Add(dt1);
182             ds1.Tables.Add(dt2);
183             ds1.DataSetName = "方案";
184             string xmlOut = XmlDatasetConvert.ConvertDataSetToXML(ds1);
185             #endregion
186 
187             //转换一个XML字符串为一个DataSet
188             #region 转换一个XML字符串为一个DataSet
189             DataSet ds2 = new DataSet();
190             ds2 = XmlDatasetConvert.ConvertXMLToDataSet(xmlOut);
191             Console.WriteLine("数据集名为"{0}",包含{1}个表", ds2.DataSetName, ds2.Tables.Count);
192             foreach (DataTable dt in ds2.Tables)
193             {
194                 PrintTableName(dt.TableName);
195             };
196             #endregion
197 
198             //转换一个Dataset为一个XML文件
199             #region 转换一个Dataset为一个XML文件
200             XmlDatasetConvert.ConvertDataSetToXMLFile(ds2, "c:\adadsda1.xml");
201             #endregion
202             
203             Console.ReadLine();
204         }
205 
206         private static void PrintTableName(string tableName)
207         {
208             Console.WriteLine(tableName);
209         }
210     }
211 }