C产品在市场上有哪些独特优势？

本文共计775个文字，预计阅读时间需要4分钟。

将DataTable转换为XML的简单步骤如下：

1. 创建一个XML文档对象。

2.创建一个根元素，例如``。

3.遍历DataTable中的每一行。

4.对于每一行，创建一个XML元素，例如``。

5.遍历行中的每个列，为每个列创建一个XML元素，例如``，并设置其属性为列名和值。

6.将每个列元素添加到行元素中。

7.将行元素添加到根元素中。

8.将根元素添加到XML文档中。

9.保存或输出XML文档。

示例代码（假设使用C#）：

csharp

using System;using System.Data;using System.Xml;

public class DataTableToXml{ public static string ConvertDataTableToXml(DataTable dt) { XmlWriterSettings settings=new XmlWriterSettings(); settings.Indent=true; settings.OmitXmlDeclaration=true;

using (XmlWriter writer=XmlWriter.Create(new StringWriter(), settings)) { writer.WriteStartElement(Data);

foreach (DataRow row in dt.Rows) { writer.WriteStartElement(Row);

foreach (DataColumn column in dt.Columns) { writer.WriteElementString(column.ColumnName, row[column].ToString()); }

writer.WriteEndElement(); }

writer.WriteEndElement(); }

return ((StringWriter)writer.BaseStream).ToString(); }}

使用示例：

csharpDataTable dt=new DataTable();dt.Columns.Add(ID, typeof(int));dt.Columns.Add(Name, typeof(string));dt.Rows.Add(1, Alice);dt.Rows.Add(2, Bob);

string xmlOutput=DataTableToXml.ConvertDataTableToXml(dt);Console.WriteLine(xmlOutput);

输出结果：

xml 1 Alice 2 Bob

一、DataTable转XML

#region DataTableToXml /// <summary> /// 将DataTable对象转换成XML字符串 /// </summary> /// <param name="ds">DataSet对象</param> /// <returns>XML字符串</returns> public static string DataTableToXml(DataTable dt,string sName) { if (dt != null) { MemoryStream ms = null; XmlTextWriter XmlWt = null; try { ms = new MemoryStream(); //根据ms实例化XmlWt XmlWt = new XmlTextWriter(ms, System.Text.Encoding.Unicode); //获取ds中的数据 dt.TableName = Sql.IsEmptyString(sName) ? "dt2xml" : sName; dt.WriteXml(XmlWt, XmlWriteMode.WriteSchema); int count = (int)ms.Length; byte[] temp = new byte[count]; ms.Seek(0, SeekOrigin.Begin); ms.Read(temp, 0, count); //返回Unicode编码的文本 System.Text.UnicodeEncoding ucode = new System.Text.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 ""; } } #endregion

二、XML转Dataset

方法A:

#region Xml To DataSet public static DataSet XmlToDataSet(string xmlString) { XmlDocument xmldoc = new XmlDocument(); xmldoc.LoadXml(xmlString); StringReader stream = null; XmlTextReader reader = null; try { DataSet xmlDS = new DataSet(); stream = new StringReader(xmldoc.InnerXml); reader = new XmlTextReader(stream); xmlDS.ReadXml(reader); reader.Close(); return xmlDS; } catch (System.Exception ex) { reader.Close(); throw ex; } } #endregion

方法B:

private static DataSet XMLToDataset() { string strDBXMLFile = @"F:\TestDir\XML\DBTEST.XML"; DataSet dsXML = new DataSet(); dsXML.ReadXml(strDBXMLFile); //某个节点名称的所有节点内容 DataTable dtOneNote = dsXML.Tables["SMT"]; return dsXML; }

三、Dataset转XML

public static string ConvertDataSetToXML(DataSet xmlDS) { MemoryStream stream = null; XmlTextWriter writer = null; try { stream = new MemoryStream(); //从stream装载到XmlTextReader writer = new XmlTextWriter(stream, Encoding.Unicode); //用WriteXml方法写入文件. xmlDS.WriteXml(writer); int count = (int)stream.Length; byte[] arr = new byte[count]; stream.Seek(0, SeekOrigin.Begin); stream.Read(arr, 0, count); UnicodeEncoding utf = new UnicodeEncoding(); return utf.GetString(arr).Trim(); } catch (System.Exception ex) { throw ex; } finally { if (writer != null) writer.Close(); } }

四、Dataset转XML文件

public static void ConvertDataSetToXMLFile(DataSet xmlDS, string xmlFile) { MemoryStream stream = null; XmlTextWriter writer = null; try { stream = new MemoryStream(); //从stream装载到XmlTextReader writer = new XmlTextWriter(stream, Encoding.Unicode); //用WriteXml方法写入文件. xmlDS.WriteXml(writer); int count = (int)stream.Length; byte[] arr = new byte[count]; stream.Seek(0, SeekOrigin.Begin); stream.Read(arr, 0, count); //返回Unicode编码的文本 UnicodeEncoding utf = new UnicodeEncoding(); StreamWriter sw = new StreamWriter(xmlFile); sw.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>"); sw.WriteLine(utf.GetString(arr).Trim()); sw.Close(); } catch (System.Exception ex) { throw ex; } finally { if (writer != null) writer.Close(); } }

到此这篇关于C#实现XML文件与DataTable、Dataset互转的文章就介绍到这了。希望对大家的学习有所帮助，也希望大家多多支持自由互联。