C#怎么将DataTable导出为XML文件_C#实现DataTable数据导出XML格式

using System;
using System.Data;

// 创建一个示例DataTable
DataTable table = new DataTable("Users");
table.Columns.Add("ID", typeof(int));
table.Columns.Add("Name", typeof(string));
table.Columns.Add("Age", typeof(int));

// 添加几行数据
table.Rows.Add(1, "张三", 25);
table.Rows.Add(2, "李四", 30);
table.Rows.Add(3, "王五", 28);

// 导出为XML文件
table.WriteXml("users.xml");

<?xml version="1.0" standalone="true"?>
<DocumentElement>
  <Users>
    <ID>1</ID>
    <Name>张三</Name>
    <Age>25</Age>
  </Users>
  <Users>
    <ID>2</ID>
    <Name>李四</Name>
    <Age>30</Age>
  </Users>
  <Users>
    <ID>3</ID>
    <Name>王五</Name>
    <Age>28</Age>
  </Users>
</DocumentElement>

// 同时写入数据和结构
table.WriteXml("users_data.xml");
table.WriteXmlSchema("users_schema.xsd");

using (var writer = new System.IO.StringWriter()) {
    table.WriteXml(writer, XmlWriteMode.WriteSchema);
    string xmlWithSchema = writer.ToString();
    System.IO.File.WriteAllText("users_with_schema.xml", xmlWithSchema);
}

DataSet ds = new DataSet("MyData");
ds.Tables.Add(table);
ds.WriteXml("custom_root.xml");