Question

怎么由DataTable转化为XML-CSDN论坛

Answer 1

dataTable和dataSet自带转化为xml的功能:

dt.WriteXml(stream);
ds.WriteXml(stream);

示例方法:

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();
     }
}