DataSet XMl DateTable 互转

最新推荐文章于 2025-12-11 21:03:14 发布

原创最新推荐文章于 2025-12-11 21:03:14 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #xml #string

本文介绍了如何将DataTable和DataSet转换为XML字符串的方法，并提供了从XML字符串还原为数据表(DataTable)和数据集(DataSet)的技术实现。这些方法在数据交换和持久化的场景中非常实用。

/// <summary> /// DataTable-------------------->XML --String /// </summary> public static String ToXmlString(DataTable dt) { StringWriter tr = new StringWriter(); try { dt.WriteXml(tr); return tr.ToString(); } catch { throw; } finally { tr.Dispose(); } } /// <summary> /// DataSet----------------->XML---String /// </summary> public static String ToXmlString(DataSet ds) { StringWriter tr = new StringWriter(); try { ds.WriteXml(tr, XmlWriteMode.IgnoreSchema); return tr.ToString(); } catch { throw; } finally { tr.Dispose(); } } /// <summary> /// xml转换为数据集 /// </summary> public static DataSet XmlToDataSet(string xml) { try { StringReader sr = new StringReader(xml); DataSet ds = new DataSet(); ds.ReadXml(sr); return ds; } catch { throw; } } /// <summary> /// Xml转换为数据表 /// </summary> public static DataTable ToDataTable(string xmlData, int TableIndex) { try { return XmlToDataSet(xmlData).Tables[TableIndex]; } catch { throw; } }