将String XML转换为C#中的数据表

using System;
using System.Data;
using System.Xml;

public class XmlToDataTableConverter
{
    public static DataTable Convert(string xmlString)
    {
        DataTable dataTable = new DataTable();
        XmlDocument xmlDoc = new XmlDocument();
        xmlDoc.LoadXml(xmlString);
        XmlElement xmlRoot = xmlDoc.DocumentElement;

        // 读取XML中的列名
        foreach (XmlNode node in xmlRoot.ChildNodes[0].Attributes)
        {
            dataTable.Columns.Add(node.Name, typeof(string));
        }

        // 读取XML中的数据行
        foreach (XmlNode node in xmlRoot.ChildNodes)
        {
            DataRow dataRow = dataTable.NewRow();
            foreach (XmlAttribute attr in node.Attributes)
            {
                dataRow[attr.Name] = attr.Value;
            }
            dataTable.Rows.Add(dataRow);
        }

        return dataTable;
    }
}