C# read xml datatable in datatable

Question

I need to read datatable in datatabele in xml file. For instance I have this xml settings:

<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>

So I can read Dev_1 as a table, but I cannot read SupplyVoltageMeasurement as a table. So how do I read datatable SupplyVoltageMeasurement in datatable Dev_1?

manish · Accepted Answer · 2015-07-01 10:32:52Z

1

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;
}

answered Jul 1, 2015 at 10:32

manish

1,4588 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tolga Evcimen · Accepted Answer · 2015-07-01 09:02:33Z

1

Initialize the xml with XElement class. After that it is really easy to use.

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
}

answered Jul 1, 2015 at 9:02

Tolga Evcimen

7,39011 gold badges63 silver badges97 bronze badges

Collectives™ on Stack Overflow

C# read xml datatable in datatable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related