How to get an xml node element value using XDocument?

Question

Here I am listing an xml.

<?xml version="1.0" encoding="utf-8" ?>
<data>
    <dataitem>
        qqqqqqq
    </dataitem>
    <templatedata>
        <Year>2001</Year>
    </templatedata>
    <mailmergedata>
        <row>
            <facilityname>ABC Corporation</facilityname>
            <dueamount>200.00</dueamount>
        </row>
        <row>
            <facilityname>XYZ Corporation</facilityname>
            <DueAmount>50.00</DueAmount>
        </row>
    </mailmergedata>
</data>

I want to retrive the value of the node facilityname Anybody pls help

score 1 · Answer 1 · edited May 23 '17 at 12:18

1

try this:

XDocument xmlFile = XDocument.Load("xml file path");
var query = from c in xmlFile.Descendants("facilityname ") select c;

then

foreach (XElement element in query)
{
    Console.WriteLine(element); // get your value here
}

Refer Job Skeet's answer, that may help you ..

edited May 23 '17 at 12:18

Community

1
1

answered Nov 27 '12 at 11:07

Niranjan Singh

18,017
2
42
75

score 1 · Answer 2 · answered Nov 27 '12 at 11:08

1

You can also use XPathSelectElements and then use XPath to navigate:

xdoc.XPathSelectElements("/data/mailmergedata/row/facilityname")

answered Nov 27 '12 at 11:08

StuartLC

104,537
17
209
285

1

And you have to remember to add: using System.Xml.XPath. – banana Nov 27 '12 at 11:18

How to get an xml node element value using XDocument?

2 Answers2