实现XML与DataTable互转 .NET

最新推荐文章于 2019-02-25 18:00:00 发布

转载最新推荐文章于 2019-02-25 18:00:00 发布 · 120 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/jx270/archive/2013/03/12/2956495.html

本文分享了在.NET环境中实现XML文件与DataTable相互转换的实用函数。通过详细代码示例，展示了如何将DataTable数据导出为XML格式，以及如何从XML读取数据并将其解析为DataTable，便于数据交换和持久化。

实现XML与DataTable互转 .NET

XML与Datatable互换的两个函数：

 
      private string ConvertDataTableToXML(DataTable xmlDS) 
          { 
              MemoryStream stream = null; 
              XmlTextWriter writer = null; 
              try 
              { 
                  stream = new MemoryStream(); 
                  writer = new XmlTextWriter(stream, Encoding.Default); 
                  xmlDS.WriteXml(writer); 
                  int count = (int)stream.Length; 
                  byte[] arr = new byte[count]; 
                  stream.Seek(0, SeekOrigin.Begin); 
                  stream.Read(arr, 0, count); 
                  UTF8Encoding utf = new UTF8Encoding(); 
                  return utf.GetString(arr).Trim(); 
              } 
              catch 
              { 
                  return String.Empty; 
              } 
              finally 
              { 
                  if (writer != null) writer.Close(); 
              } 
          }  
          private DataSet ConvertXMLToDataSet(string xmlData) 
          { 
            StringReader stream = null; 
            XmlTextReader reader = null; 
            try 
            { 
              DataSet xmlDS = new DataSet(); 
              stream = new StringReader(xmlData); 
              reader = new XmlTextReader(stream); 
              xmlDS.ReadXml(reader); 
              return xmlDS; 
            } 
            catch (Exception ex) 
            { 
              string strTest = ex.Message; 
              return null; 
            } 
            finally 
            { 
              if (reader != null) 
              reader.Close(); 
            } 
          } 
     

posted on 2013-03-12 21:22 v.e.n.u.s 阅读( ...) 评论( ...) 编辑收藏

转载于:https://www.cnblogs.com/jx270/archive/2013/03/12/2956495.html