How to get XML node values

Question

I have an xml that looks like this:

<ProductTemplate ProductName="FlamingoWhistle" Version="1.8.02" >
    <Whistle Type="Red" Version="3.0.5" />
        <Size Type="Large" Version="1.0" />
    <Whistle Type="Blue" Version="2.4.3" />
</ProductTemplate>

How can I check if type equals red, return the version for that type?
This is what I have tried but fails if the element isn't first

XElement root = XElement.Load(path);

if (XPathSelectElement("Whistle").Attribute("Type") == "Blue")
{
    Console.WriteLine(XPathSelectElement("Whistle").Attribute("Version").value));
}
else
{
    Console.WriteLine("Sorry, no FlamingoWhistle in that color");
}

pushpraj · Accepted Answer · 2014-07-25 02:23:52Z

1

this should do the trick

foreach(XElement xe in root.Elements("Whistle"))
{
    if (xe.Attribute("Type").Value == "Red")
    {
        Console.WriteLine(xe.Attribute("Version").Value);
    }
}

use linq

string version = root.Elements("Whistle")
                 .Where(x => x.Attribute("Type").Value == "Red")
                 .First().Attribute("Version").Value;

xpath

string version = root.XPathSelectElement("Whistle[@Type='Red']").Attribute("Version").Value;

update

first of all you may need to correct the xml for property hierarchy, in your current xml element Size is not a child of Whistle. i assume it to be the child

<ProductTemplate ProductName="FlamingoWhistle" Version="1.8.02">
    <Whistle Type="Red" Version="3.0.5">
        <Size Type="Large" Version="1.0" /> 
    </Whistle>
    <Whistle Type="Blue" Version="2.4.3" /> 
</ProductTemplate>

retrieving the version from size element

foreach (XElement xe in root.Elements("Whistle"))
{
    if (xe.Attribute("Type").Value == "Red")
    {
        Console.WriteLine(xe.Element("Size").Attribute("Version").Value);
    }
}

linq

string version = root.Elements("Whistle")
     .Where(x => x.Attribute("Type").Value == "Red")
     .First().Element("Size").Attribute("Version").Value;

xpath

string version = root.XPathSelectElement("Whistle[@Type='Red']/Size").Attribute("Version").Value;

edited Jul 25, 2014 at 2:23

answered Jul 24, 2014 at 14:09

pushpraj

13.7k3 gold badges38 silver badges52 bronze badges

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

1 Comment

John Smith Over a year ago

what if i want to get the value of version in the size node if the whistle type is red? Check out the edit.

Collectives™ on Stack Overflow

How to get XML node values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related