XML与DataTableDataSet互转(C#源码)把数据库中表的内容转存为XML.doc

DataSet(DataTable)与XML互转加引用：usingSystem;usingSystem.Data;usingSystem.IO;usingSystem.Xml;usingSystem.Text;/相应C#代码：privatestringConvertDataTableToXML(DataTablexmlDS)Memo.加引用： usingSystem; usingSystem.Data; usingSystem.IO; usingSystem.Xml; usingSystem.Text; /相应C#代码： privatestringConvertDataTableToXML(DataTablexmlDS) MemoryStreamstream=null; XmlTextWriterwriter=null; try stream=newMemoryStream(); writer=newXmlTextWriter(stream,Encoding.Default); xmlDS.WriteXml(writer); intcount=(int)stream.Length; bytearr=newbytecount; stream.Seek(0,SeekOrigin.Begin); stream.Read(arr,0,count); UTF8Encodingutf=newUTF8Encoding(); returnutf.GetString(arr).Trim(); catch returnString.Empty; finally if(writer!=null)writer.Close(); privateDataSetConvertXMLToDataSet(stringxmlData) StringReaderstream=null; XmlTextReaderreader=null; try DataSetxmlDS=newDataSet(); stream=newStringReader(xmlData); reader=newXmlTextReader(stream); xmlDS.ReadXml(reader); returnxmlDS; catch(Exceptionex) stringstrTest=ex.Message; returnnull; finally if(reader!=null) reader.Close(); XML与DataTable/DataSet互转(C#) 把数据库中表的内容转存为XML文件Xml 2009-09-24 13:47:25 阅读47 评论0 字号：大中小订阅/*/ / 把DataSet、DataTable、DataView格式转换成XML字符串、XML文件 / public class DataToXml /*/ / 将DataTable对象转换成XML字符串 / / DataTable对象 / XML字符串 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 bytecount; 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 ; /*/ / 将DataSet对象中指定的Table转换成XML字符串 / / DataSet对象 / DataSet对象中的Table索引 / XML字符串 public static string CDataToXml(DataSet ds, int tableIndex) if (tableIndex != -1) return CDataToXml(ds.TablestableIndex); else return CDataToXml(ds.Tables0); /*/ / 将DataSet对象转换成XML字符串 / / DataSet对象 / XML字符串 public static string CDataToXml(DataSet ds) return CDataToXml(ds, -1); /*/ / 将DataView对象转换成XML字符串 / / DataView对象 / XML字符串 public static string CDataToXml(DataView dv) return CDataToXml(dv.Table); /*/ / 将DataSet对象数据保存为XML文件 / / DataSet / XML文件路径 / bool值 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 bytecount; ms.Seek(0, SeekOrigin.Begin); ms.Read(temp, 0, count); /返回Unicode编码的文本 UnicodeEncoding ucode = new UnicodeEncoding(); /写文件 StreamWriter sw = new StreamWriter(path); sw.WriteLine(); 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; /*/ / 将DataSet对象中指定的Table转换成XML文件 / / DataSet对象 / DataSet对象中的Table索引 / xml文件路径 / bool值 public static bool CDataToXmlFile(DataSet ds, int tableIndex, string xmlFilePath) if (tableIndex != -1) return CDataToXmlFile(ds.TablestableIndex, xmlFilePath); else return CDataToXmlFile(ds.Tables0, xmlFilePath); /*/ / 将DataSet对象转换成XML文件 / / DataSet对象 / xml文件路径 / bool值 public static bool CDataToXmlFile(DataSet ds, string xmlFilePath) return CDataToXmlFile(ds, -1, xmlFilePath); /*/ / 将DataView对象转换成XML文件 / / DataView对象 / xml文件路径 / bool值 public static bool CDataToXmlFile(DataView dv, string xmlFilePath) return CDataToXmlFile(dv.Table, xmlFilePath); /*/ / XML形式的字符串、XML文江转换成DataSet、DataTable格式 / public class XmlToData /*/ / 将Xml内容字符串转换成DataSet对象 / / Xml内容字符串 / DataSet对象 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; /*/ / 将Xml字符串转换成DataTable对象 / / Xml字符串 / Table表索引 / DataTable对象 public static DataTable CXmlToDatatTable(string xmlStr, int tableIndex) return CXmlToDataSet(xmlStr).TablestableIndex; /*/ / 将Xml字符串转换成DataTable对象 / / Xml字符串 / DataTable对象 public static DataTable CXmlToDatatTable(string xmlStr) return CXmlToDataSet(xmlStr).Tables0; /*/ / 读取Xml文件信息,并转换成DataSet对象 / / / DataSet ds = new DataSet(); / ds = CXmlFileToDataSet(/XML/upload.xml); / / Xml文件地址 / DataSet对象 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; /*/ / 读取Xml文件信息,并转换成DataTable对象 / / xml文江路径 / Table索引 / DataTable对象 public static DataTable CXmlToDataTable(string xmlFilePath, int tableIndex) return CXmlFileToDataSet(xmlFilePath).TablestableIndex; /*/ / 读取Xml文件信息,并转换成DataTable对象 / / xml文江路径 / DataTable对象 public static DataTable CXmlToDataTable(string xmlFilePath) return CXmlFileToDataSet(xmlFilePath).Tables0; 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 bytecount; 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(); 把数据库中表的内容转存为XML文件SqlConnection conn = new SqlConnection(server=.;database=db;uid=sa;pwd=);SqlCommand cmd = conn.CreateCommand();/把列的内容作为属性，根元素名子为cmd.CommandText = select * from student for xml auto,root(root); conn.Open();XmlReader xr = cmd.ExecuteXmlReader();XmlDocument dd = new XmlDocument();dd.Load(xr); ;XmlNode xx = dd.FirstChild; /取得根元素XmlDeclaration xd = dd.CreateXmlDeclaration(1.0, utf-8, yes); /创建XML声明dd.InsertBefore(xd,xx); /在根元素前加入XML声明dd.Save(Server.MapPath(tt.config);conn.Close();执行结果：如果把上面的SqlCommand对象的CommandText改为如下：cmd.CommandText = select * from student for xml auto,root(root),elements;执行结果如下： 101 李军 男 1976-02-20T00:00:00 95033 103 陆君 男 1974-06-03T00:00:00 95031-XML与DataTable/DataSet互转(C#)2010年12月23日 评论 发表评论 /*/ 把DataSet、DataTable、DataView格式转换成XML字符串、XML文件/ public class DataToXml/*/ 将DataTable对象转换成XML字符串/ / DataTable对象 / XML字符串public static string CDataToXml(DataTable dt)if (dt != null)MemoryStream ms = null;XmlTextWriter XmlWt = null;tryms = new MemoryStream();/根据ms实例化XmlWtXmlWt = new XmlTextWriter(ms, Encoding.Unicode);/获取ds中的数据dt.WriteXml(XmlWt);int count = (int)ms.Length;byte temp = new bytecount;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();elsereturn “”;/*/ 将DataSet对象中指定的Table转换成XML字符串/ / DataSet对象 / DataSet对象中的Table索引 / XML字符串public static string CDataToXml(DataSet ds, int tableIndex)if (tableIndex != -1)return CDataToXml(ds.TablestableIndex);elsereturn CDataToXml(ds.Tables0);/*/ 将DataSet对象转换成XML字符串/ / DataSet对象 / XML字符串public static string CDataToXml(DataSet ds)return CDataToXml(ds, -1);/*/ 将DataView对象转换成XML字符串/ / DataView对象 / XML字符串public static string CDataToXml(DataView dv)return CDataToXml(dv.Table);/*/ 将DataSet对象数据保存为XML文件/ / DataSet / XML文件路径 / bool值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;tryms = new MemoryStream();/根据ms实例化XmlWtXmlWt = new XmlTextWriter(ms, Encoding.Unicode);/获取ds中的数据dt.WriteXml(XmlWt);int count = (int)ms.Length;byte temp = new bytecount;ms.Seek(0, SeekOrigin.Begin);ms.Read(temp, 0, count);/返回Unicode编码的文本UnicodeEncoding ucode = new UnicodeEncoding();/写文件StreamWriter sw = new StreamWriter(path);sw.WriteLine(“”);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();elsereturn false;/*/ 将DataSet对象中指定的Table转换成XML文件/ / DataSet对象 / DataSet对象中的Table索引 / xml文件路径 / bool值public static bool CDataToXmlFile(DataSet ds, int tableIndex, string xmlFilePath)if (tableIndex != -1)return CDataToXmlFile(ds.TablestableIndex, xmlFilePath);elsereturn CDataToXmlFile(ds.Tables0, xmlFilePath);/*/ 将DataSet对象转换成XML文件/ / DataSet对象 / xml文件路径 / bool值public static bool CDataToXmlFile(DataSet ds, string xmlFilePath)return CDataToXmlFile(ds, -1, xmlFilePath);/*/ 将DataView对象转换成XML文件/ / DataView对象 / xml文件路径 / bool值public static bool CDataToXmlFile(DataView dv, string xmlFilePath)return CDataToXmlFile(dv.Table, xmlFilePath);/*/ XML形式的字符串、XML文江转换成DataSet、DataTable格式/ public class XmlToData/*/ 将Xml内容字符串转换成DataSet对象/ / Xml内容字符串 / DataSet对象public static DataSet CXmlToDataSet(string xmlStr)if (!string.IsNullOrEmpty(xmlStr)StringReader