转载把DataSet、DataTable、DataView格式转换成XML字符串、XML文件

public class DataToXml 

    { 

        /**//// <summary> 

        /// 将DataTable对象转换成XML字符串 

        /// </summary> 

        /// <param name="dt">DataTable对象</param> 

        /// <returns>XML字符串</returns> 

        public static string CDataToXml(DataTable dt) 

        { 

            if (dt != null) 

            { 

                MemoryStream ms = null; 

                XmlTextWriter XmlWt = null; 

                try 

                { 

                    ms = new MemoryStream(); 

                    //根据ms实例化XmlWt 

                    XmlWt = new XmlTextWriter(ms, Encoding.Unicode); 

                    //获取ds中的数据 

                    dt.WriteXml(XmlWt); 

                    int count = (int)ms.Length; 

                    byte[] temp = new byte[count]; 

                    ms.Seek(0, SeekOrigin.Begin); 

                    ms.Read(temp, 0, count); 

                    //返回Unicode编码的文本 

                    UnicodeEncoding ucode = new UnicodeEncoding(); 

                    string returnValue = ucode.GetString(temp).Trim(); 

                    return returnValue; 

                } 

                catch (System.Exception ex) 

                { 

                    throw ex; 

                } 

                finally 

                { 

                    //释放资源 

                    if (XmlWt != null) 

                    { 

                        XmlWt.Close(); 

                        ms.Close(); 

                        ms.Dispose(); 

                    } 

                } 

            } 

            else 

            { 

                return ""; 

            } 

        } 

        /**//// <summary> 

        /// 将DataSet对象中指定的Table转换成XML字符串 

        /// </summary> 

        /// <param name="ds">DataSet对象</param> 

        /// <param name="tableIndex">DataSet对象中的Table索引</param> 

        /// <returns>XML字符串</returns> 

        public static string CDataToXml(DataSet ds, int tableIndex) 

        { 

            if (tableIndex != -1) 

            { 

                return CDataToXml(ds.Tables[tableIndex]); 

            } 

            else 

            { 

                return CDataToXml(ds.Tables[0]); 

            } 

        } 

        /**//// <summary> 

        /// 将DataSet对象转换成XML字符串 

        /// </summary> 

        /// <param name="ds">DataSet对象</param> 

        /// <returns>XML字符串</returns> 

        public static string CDataToXml(DataSet ds) 

        { 

            return CDataToXml(ds, -1); 

        } 

        /**//// <summary> 

        /// 将DataView对象转换成XML字符串 

        /// </summary> 

        /// <param name="dv">DataView对象</param> 

        /// <returns>XML字符串</returns> 

        public static string CDataToXml(DataView dv) 

        { 

            return CDataToXml(dv.Table); 

        } 

        /**//// <summary> 

        /// 将DataSet对象数据保存为XML文件 

        /// </summary> 

        /// <param name="dt">DataSet</param> 

        /// <param name="xmlFilePath">XML文件路径</param> 

        /// <returns>bool值</returns> 

        public static bool CDataToXmlFile(DataTable dt, string xmlFilePath) 

        { 

            if ((dt != null) && (!string.IsNullOrEmpty(xmlFilePath))) 

            { 

                string path = HttpContext.Current.Server.MapPath(xmlFilePath); 

                MemoryStream ms = null; 

                XmlTextWriter XmlWt = null; 

                try 

                { 

                    ms = new MemoryStream(); 

                    //根据ms实例化XmlWt 

                    XmlWt = new XmlTextWriter(ms, Encoding.Unicode); 

                    //获取ds中的数据 

                    dt.WriteXml(XmlWt); 

                    int count = (int)ms.Length; 

                    byte[] temp = new byte[count]; 

                    ms.Seek(0, SeekOrigin.Begin); 

                    ms.Read(temp, 0, count); 

                    //返回Unicode编码的文本 

                    UnicodeEncoding ucode = new UnicodeEncoding(); 

                    //写文件 

                    StreamWriter sw = new StreamWriter(path); 

                    sw.WriteLine("<?xml version="1.0" encoding="utf-8"?>"); 

                    sw.WriteLine(ucode.GetString(temp).Trim()); 

                    sw.Close(); 

                    return true; 

                } 

                catch (System.Exception ex) 

                { 

                    throw ex; 

                } 

                finally 

                { 

                    //释放资源 

                    if (XmlWt != null) 

                    { 

                        XmlWt.Close(); 

                        ms.Close(); 

                        ms.Dispose(); 

                    } 

                } 

            } 

            else 

            { 

                return false; 

            } 

        } 

        /**//// <summary> 

        /// 将DataSet对象中指定的Table转换成XML文件 

        /// </summary> 

        /// <param name="ds">DataSet对象</param> 

        /// <param name="tableIndex">DataSet对象中的Table索引</param> 

        /// <param name="xmlFilePath">xml文件路径</param> 

        /// <returns>bool]值</returns> 

        public static bool CDataToXmlFile(DataSet ds, int tableIndex, string xmlFilePath) 

        { 

            if (tableIndex != -1) 

            { 

                return CDataToXmlFile(ds.Tables[tableIndex], xmlFilePath); 

            } 

            else 

            { 

                return CDataToXmlFile(ds.Tables[0], xmlFilePath); 

            } 

        } 

        /**//// <summary> 

        /// 将DataSet对象转换成XML文件 

        /// </summary> 

        /// <param name="ds">DataSet对象</param> 

        /// <param name="xmlFilePath">xml文件路径</param> 

        /// <returns>bool]值</returns> 

        public static bool CDataToXmlFile(DataSet ds, string xmlFilePath) 

        { 

            return CDataToXmlFile(ds, -1, xmlFilePath); 

        } 

        /**//// <summary> 

        /// 将DataView对象转换成XML文件 

        /// </summary> 

        /// <param name="dv">DataView对象</param> 

        /// <param name="xmlFilePath">xml文件路径</param> 

        /// <returns>bool]值</returns> 

        public static bool CDataToXmlFile(DataView dv, string xmlFilePath) 

        { 

            return CDataToXmlFile(dv.Table, xmlFilePath); 

        } 

    } 

/**//// <summary> 

    /// XML形式的字符串、XML文江转换成DataSet、DataTable格式 

    /// </summary> 

    public class XmlToData 

    { 

        /**//// <summary> 

        /// 将Xml内容字符串转换成DataSet对象 

        /// </summary> 

        /// <param name="xmlStr">Xml内容字符串</param> 

        /// <returns>DataSet对象</returns> 

        public static DataSet CXmlToDataSet(string xmlStr) 

        { 

            if (!string.IsNullOrEmpty(xmlStr)) 

            { 

                StringReader StrStream = null; 

                XmlTextReader Xmlrdr = null; 

                try 

                { 

                    DataSet ds = new DataSet(); 

                    //读取字符串中的信息 

                    StrStream = new StringReader(xmlStr); 

                    //获取StrStream中的数据 

                    Xmlrdr = new XmlTextReader(StrStream); 

                    //ds获取Xmlrdr中的数据 

                    ds.ReadXml(Xmlrdr); 

                    return ds; 

                } 

                catch (Exception e) 

                { 

                    throw e; 

                } 

                finally 

                { 

                    //释放资源 

                    if (Xmlrdr != null) 

                    { 

                        Xmlrdr.Close(); 

                        StrStream.Close(); 

                        StrStream.Dispose(); 

                    } 

                } 

            } 

            else 

            { 

                return null; 

            } 

        } 

        /**//// <summary> 

        /// 将Xml字符串转换成DataTable对象 

        /// </summary> 

        /// <param name="xmlStr">Xml字符串</param> 

        /// <param name="tableIndex">Table表索引</param> 

        /// <returns>DataTable对象</returns> 

        public static DataTable CXmlToDatatTable(string xmlStr, int tableIndex) 

        { 

            return CXmlToDataSet(xmlStr).Tables[tableIndex]; 

        } 

        /**//// <summary> 

        /// 将Xml字符串转换成DataTable对象 

        /// </summary> 

        /// <param name="xmlStr">Xml字符串</param> 

        /// <returns>DataTable对象</returns> 

        public static DataTable CXmlToDatatTable(string xmlStr) 

        { 

            return CXmlToDataSet(xmlStr).Tables[0]; 

        } 

        /**//// <summary> 

        /// 读取Xml文件信息,并转换成DataSet对象 

        /// </summary> 

        /// <remarks> 

        /// DataSet ds = new DataSet(); 

        /// ds = CXmlFileToDataSet("/XML/upload.xml"); 

        /// </remarks> 

        /// <param name="xmlFilePath">Xml文件地址</param> 

        /// <returns>DataSet对象</returns> 

        public static DataSet CXmlFileToDataSet(string xmlFilePath) 

        { 

            if (!string.IsNullOrEmpty(xmlFilePath)) 

            { 

                string path = HttpContext.Current.Server.MapPath(xmlFilePath); 

                StringReader StrStream = null; 

                XmlTextReader Xmlrdr = null; 

                try 

                { 

                    XmlDocument xmldoc = new XmlDocument(); 

                    //根据地址加载Xml文件 

                    xmldoc.Load(path); 

                    DataSet ds = new DataSet(); 

                    //读取文件中的字符流 

                    StrStream = new StringReader(xmldoc.InnerXml); 

                    //获取StrStream中的数据 

                    Xmlrdr = new XmlTextReader(StrStream); 

                    //ds获取Xmlrdr中的数据 

                    ds.ReadXml(Xmlrdr); 

                    return ds; 

                } 

                catch (Exception e) 

                { 

                    throw e; 

                } 

                finally 

                { 

                    //释放资源 

                    if (Xmlrdr != null) 

                    { 

                        Xmlrdr.Close(); 

                        StrStream.Close(); 

                        StrStream.Dispose(); 

                    } 

                } 

            } 

            else 

            { 

                return null; 

            } 

        } 

        /**//// <summary> 

        /// 读取Xml文件信息,并转换成DataTable对象 

        /// </summary> 

        /// <param name="xmlFilePath">xml文江路径</param> 

        /// <param name="tableIndex">Table索引</param> 

        /// <returns>DataTable对象</returns> 

        public static DataTable CXmlToDataTable(string xmlFilePath, int tableIndex) 

        { 

            return CXmlFileToDataSet(xmlFilePath).Tables[tableIndex]; 

        } 

        /**//// <summary> 

        /// 读取Xml文件信息,并转换成DataTable对象 

        /// </summary> 

        /// <param name="xmlFilePath">xml文江路径</param> 

        /// <returns>DataTable对象</returns> 

        public static DataTable CXmlToDataTable(string xmlFilePath) 

        { 

            return CXmlFileToDataSet(xmlFilePath).Tables[0]; 

        } 

    } 

using System; 

using System.Data; 

using System.IO; 

using System.Xml; 

using System.Text; 

// 相应C#代码： 

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

   } 

}