c# - 阅读双重嵌套的xml

我正在尝试读取以下XML文件

<Tabellen>
<Header>
    <Tables>
        <Table>SW_RL</Table>
            <Fields>
                <Field>KeyVeld</Field>
                <Type>Alpha</Type>
                <Size>100</Size>
                <SubType>st_none</SubType>
            </Fields>
            <Fields>
                <Field>ErrorCode</Field>
                <Type>Alpha</Type>
                <Size>50</Size>
                <SubType>st_none</SubType>
            </Fields>
            <Fields>
                <Field>Description</Field>
                <Type>Memo</Type>
                <Size>100</Size>
                <SubType>st_none</SubType>
            </Fields>
        </Tables>
</Header>
<Header>
    <Tables>
        <Table>SW_RH</Table>
    <Fields>
        <Field>DocNum</Field>
        <Type>Numeric</Type>
        <Size>0</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>PaymentTerms</Field>
        <Type>Numeric</Type>
        <Size>0</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>DocDate</Field>
        <Type>Date</Type>
        <Size>0</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>Contract_Start</Field>
        <Type>Date</Type>
        <Size>0</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>Contract_End</Field>
        <Type>Date</Type>
        <Size>0</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>CardCode</Field>
        <Type>Alpha</Type>
        <Size>40</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>CardName</Field>
        <Type>Alpha</Type>
        <Size>100</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>BillToAddress</Field>
        <Type>Alpha</Type>
        <Size>100</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>ShipToAddress</Field>
        <Type>Alpha</Type>
        <Size>100</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>NumAtCard</Field>
        <Type>Alpha</Type>
        <Size>100</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>BillingPeriod</Field>
        <Type>Alpha</Type>
        <Size>10</Size>
        <SubType>st_none</SubType>
    </Fields>
    <Fields>
        <Field>AdvanceBilling</Field>
        <Type>Alpha</Type>
        <Size>10</Size>
        <SubType>st_none</SubType>
    </Fields>
    </Tables>
</Header>
</Tabellen>

当前代码

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(directory + "\\Server_Config.xml");
XmlNodeList xmlNodelist = null;
XmlNodeList xmlNodelist2 = null;

xmlNodelist = xmldoc.SelectNodes("Tabellen/Header/Tables");
foreach (XmlNode mnode in xmlNodelist)
{
    MessageBox.Show(mnode["Table"].InnerText, "ok");
     //create table

    xmlNodelist2 = xmldoc.SelectNodes("Tabellen/Header/Tables/Fields");
    foreach (XmlNode mnode2 in xmlNodelist2)
    {
        MessageBox.Show(mnode2["Field"].InnerText, "ok");
        // create fields
    }

}

总体思路是创建2个表
表1：RL包含3个字段
表2：RH包含12个字段

但是实际上结果是两个表都包含15个字段

我究竟做错了什么 ？？

最佳答案

Linq2Xml更易于使用。

XDocument xDoc = XDocument.Load("myfile.xml");
var tables = xDoc.Descendants("Header")
                .Select(h => new
                {
                    Table  = h.Descendants("Table").First().Value,
                    Fields = h.Descendants("Fields")
                              .Select(f=>new{
                                    Field = f.Element("Field").Value,
                                    Type = f.Element("Type").Value,
                                    Size = f.Element("Size").Value,
                                    SubType = f.Element("SubType").Value
                               })
                              .ToList()
                })
                .ToList();

关于c# - 阅读双重嵌套的xml，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/12753086/