• 学习笔记datatablexml转换


    温故而知新这句话很有道理,但是做到温故的人可不多,况且即使你想温故如果没有将以前的东西记录下来你也没法去温故,所以坚持记录我觉得很重要。百度上都可以找到的其实

    添加引用

    using System;

    using System.Data;

    using System.IO;

    using System.Text;

    using System.Xml;

    private string ConvertDataTableToXML(DataTable xmlDS) 

    {     

      MemoryStream stream = null;     

      XmlTextWriter writer = null;     

       try     

      {         

        stream = new MemoryStream();   

        //根据stream实例化writer      

        writer = new XmlTextWriter(stream, Encoding.Default); 

        //获取 xmlDS中的数据       

        xmlDS.WriteXml(writer);         

        int count = (int)stream.Length;         

        byte[] arr = new byte[count];

        //定位流开始位置         

        stream.Seek(0, SeekOrigin.Begin);  

        stream.Read(arr, 0, count);  

        //utf8编码格式       

        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();   

      } 

  • 相关阅读:
    Python 2 与 python 3的区别
    语法基础题
    Python运算符_ 2018-07-26
    Python 各种语句:2018-07-27
    解决在Python中使用Win32api报错的问题,No module named win32api
    在CenOS7.5里安装Redis
    下载Redis
    重置CentOS6.5的登录口令
    如何在CentOS里切换操作系统所用的语言,中英文切换
    在Ubuntu里安装Mysql5.7.23
  • 原文地址:https://www.cnblogs.com/maomaokuaile/p/2843706.html
Copyright © 2020-2023  润新知