
/// <summary>
/// 将指定DataTable转换为其等效的Xml流形式。
/// </summary>
/// <param name="table">DataTable对象</param>
/// <returns></returns>
public static string ToXmlString(DataTable table)
{
if (table == null)
{
return null;
}
StringBuilder content = new StringBuilder();
StringWriter writer = new StringWriter(content);
XmlTextWriter xmlWriter = new XmlTextWriter(writer);
try
{
DataSet ds = new DataSet();
ds.Tables.Add(table.Copy());
ds.WriteXml(xmlWriter);
return content.ToString();
}
finally
{
writer.Close();
xmlWriter.Close();
}
}
/// <summary>
/// 将指定的Xml流转换为其等效的DataSet对象。
/// </summary>
/// <param name="xmlStream">Xml流</param>
/// <returns></returns>
public static DataSet ToDataSet(string xmlStream)
{
if (xmlStream == null || xmlStream.Trim().Length == 0)
{
return null;
}
StringReader reader = new StringReader(xmlStream);
XmlTextReader xmlReader = new XmlTextReader(reader);
try
{
DataSet ds = new DataSet();
ds.ReadXml(xmlReader);
return ds;
}
finally
{
reader.Close();
xmlReader.Close();
}
}
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步