C#中DataTable与XML格式的相互转换

最新推荐文章于 2022-12-08 09:47:27 发布

转载最新推荐文章于 2022-12-08 09:47:27 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/net-sky/p/10432381.html

文章标签：

#c#

本文详细介绍了在C#中如何将DataTable对象转换为XML格式，以及如何从XML文件加载数据到DataTable，提供了实用的代码示例，帮助开发者在处理数据存储和交换时更加灵活。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、DataTable转换成XML
public string ConvertDataTableToXML(DataTable xmlDS)
        {
            MemoryStream stream = null;
            XmlTextWriter writer = null;
            try
            {
                stream = new MemoryStream();
                writer = new XmlTextWriter(stream, Encoding.UTF8);
                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();
            }
        }

 2、XML转换成DataTable
        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();
            }
        }

转载于:https://www.cnblogs.com/net-sky/p/10432381.html