Select XML Element based on another elements value

Question

<Root>
    <Sub>
        <Name>a</Name>
        <Value>1</Value>
    </Sub>
    <Sub>
        <Name>b</Name>
        <Value>2</Value>
    </Sub>
</Root>

How do I select the value of the Value element dependent upon the Name element?

Edit: In an XDocument, how do I get the value "1" when I have "a".

What *exactly* do you mean? – Jon Skeet Mar 11 '13 at 18:51 — Jon Skeet, Mar 11 '13 at 18:51

Sergey Berezovskiy · Accepted Answer · 2013-03-11T19:17:55.840

I suggest you to use casting nodes instead of accessing Value property directly:

int value = xdoc.Descendants("Sub")
                .Where(s => (string)s.Element("Name") == "a")
                .Select(s => (int)s.Element("Value"))
                .FirstOrDefault();

If default value (zero) for missing nodes does not fit your needs, then you can check required Sub element exists before getting value:

var sub = xdoc.Descendants("Sub")
              .FirstOrDefault(s => (string)s.Element("Name") == "a");

if (sub != null)            
    value = (int)sub.Element("Value");

Or simple one line with XPath and Linq:

int value = (int)xdoc.XPathSelectElement("//Sub[Name='a']/Value");

Marked as answer since I completely forgot about XPath and should've just used that. — Shawn, Mar 11 '13 at 19:24

score 1 · Answer 2 · edited May 23 '17 at 10:27

1

Well, think about it...

you can easily read XML file, just you have to check the condition if the inner text of <Name> is match with your condition than you have to read the value of <value> tag.

Here is you can get answer for how to read XML file from c# code.

edited May 23 '17 at 10:27

Community

1
1

answered Mar 11 '13 at 18:56

Sagar Upadhyay

819
2
11
31

score 1 · Answer 3 · answered Mar 11 '13 at 18:59

1

you may try this, may help

var results = from row in xdoc.Root.Descendants("Sub")
where row.Element("Name").value ="value"
select new XElement("row", row.Element("Value"));

answered Mar 11 '13 at 18:59

dotmido

1,374
3
13
29

JLRishe · Answer 4 · 2013-03-11T19:07:52.080

This should do it:

(assuming doc is an instance of XDocument)

string name = "a";
var items = doc.Descendants("Sub")
               .Where(s => (string)s.Element("Name") == name)
               .Select(s => s.Element("Value").Value);

items would result as an IEnumerable<string> in this case.

If you know you only want one value:

string name = "a";
string value = doc.Descendants("Sub")
               .Where(s => (string)s.Element("Name") == name)
               .Select(s => s.Element("Value").Value)
               .FirstOrDefault();

Select XML Element based on another elements value

4 Answers4