将XML文件加载到DataTable(而不是从数据库)

using System;
using System.Data;
using System.IO;
using System.Xml;
using System.Data.SqlClient;

public class XmlToDataTable
{
    public static void Main()
    {
        string xmlFilePath = "path/to/your/xml/file.xml";
        DataTable dataTable = new DataTable();

        // Load the XML file into a XmlDocument object
        XmlDocument xmlDoc = new XmlDocument();
        xmlDoc.Load(xmlFilePath);

        // Create a DataSet and load the XmlDocument object into it
        DataSet dataSet = new DataSet();
        dataSet.ReadXml(new XmlNodeReader(xmlDoc));

        // Get the first DataTable in the DataSet
        dataTable = dataSet.Tables[0];

        // Display the contents of the DataTable
        foreach (DataRow row in dataTable.Rows)
        {
            foreach (DataColumn column in dataTable.Columns)
            {
                Console.WriteLine(row[column]);
            }
        }
    }
}