C#读取数据表中的xml数据表

本文关键字:数据表 xml 读取 | 更新日期: 2023-09-27 18:00:33

我需要读取xml文件中datatabele中的datatable。例如,我有这样的xml设置:

<Devs>
    <Dev_1>
        <port>COM7</port>
        <addrs>1, 2</addrs>
        <SupplyVoltageMeasurement>
            <addr>2</addr>
            <channel>3</channel>
        </SupplyVoltageMeasurement>
    </Dev_1>
    <Dev_2>
        <port>COM6</port>
        <addrs>3, 4</addrs>
        <SupplyVoltageMeasurement>
            <addr>4</addr>
            <channel>3</channel>
        </SupplyVoltageMeasurement>
    </Dev_2>
    <Common>
        <BaudRate>38400</BaudRate>
        <BufferSize>30</BufferSize>
        <UpdatePeriod>50</UpdatePeriod>
        <SupplyVoltageChannel>3</SupplyVoltageChannel>
    </Common>
</Devs>

所以我可以将Dev_1作为一个表来读取,但不能将SupplyVoltageMeasurement作为一个表格来读取。那么如何读取数据表Dev_1中的数据表SupplyVoltageMeasurement呢?

C#读取数据表中的xml数据表

XElement xmlDoc = XElement.Load("SO-Question.xml"); // initialize your .xml document to read from
foreach (var handle in xmlDoc.Elements().Where(e => e.Name.ToString().StartsWith("Dev"))) // traverse each node of the .xml doc, based on a match condition, here : every node that starts with "Dev"
{
    // retrieve the value of every Element in the Node (mark the nestings)
    var devName = handle.Name;
    var port = handle.Element("port").Value;
    var addrs = handle.Element("addrs").Value;
    var addr = handle.Element("SupplyVoltageMeasurement").Element("addr").Value;
    var channel = handle.Element("SupplyVoltageMeasurement").Element("channel").Value;
}

使用XElement类初始化xml。之后,它真的很容易使用。

var xml = new XElement("xmlSTringAbove");
foreach ( var dev in xml.Elements().Where(e=>e.Name.StartsWith("Dev")) )
{
    /// this line gives Dev_1, Dev_2 ...
    var devName = dev.Name;
    var addr = dev.Element("SupplyVoltageChannel").Element("addr").Value;
    var channel = dev.Element("SupplyVoltageChannel").Element("channel").Value;
    /// use addr, channel and devName as you like
}