将DataSet(DataTable)与XML互转

最新推荐文章于 2021-08-30 21:29:43 发布

转载最新推荐文章于 2021-08-30 21:29:43 发布 · 547 阅读

文章标签：

#dataset #xml #stream #null #encoding #string

入门类专栏收录该内容

111 篇文章

订阅专栏

本文提供了将DataTable转换为XML字符串及从XML字符串读取DataSet的方法。通过使用C#中的MemoryStream和XmlTextWriter类来实现内存中操作，避免了文件系统的交互。此方法适用于需要在不同系统间交换数据的应用场景。

加引用：
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();
}
}