C# Get XML element value using XmlDocument

Question

Trying to retrieve the value of Rank in the XML file example below... the path i'm passing works fine wit the SelectNodes method, except when i add the attribute to the path then the code will skip the foreach loop

appreciate any help on how to solve this. in addition i'm looking for one value of the Rank element and its a based on specific attributes of Sub ID and Rank ID so there is no need for the loop but that's the only way i know

XML File:

<Model> <BookStore> <Book> <Sub ID="Science"> <Rank ID="Chemistry">Value1</Rank> <Rank ID="Physics">Value2</Rank> </Sub> </Book> </BookStore> </Model>

C# Code:

var myDoc = new XmlDocument();
myDoc.Load(MapPath("myXML.xml"));

XmlNodeList rankList = myDoc.SelectNodes("/Model/BookStore/Book/Sub[@ID='Science']/Rank");  // Science can be any other variable
foreach (XmlNode myRankNode in rankList)
{
    if (myRankNode.Attributes["ID"].Value.ToString() == "Physics") // Physics can be any other variable
    {
        myValue = myRankNode.InnerText;
    }

}

joemfb · Accepted Answer · 2014-01-30 21:49:18Z

1

You should be able to just do this:

 myDoc.SelectNodes("/Model/BookStore/Book/Sub[@ID='Science']/Rank[@ID='Physics']");

And then confirm that you got exactly one result.

answered Jan 30, 2014 at 21:49

joemfb

3,05622 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

C# Get XML element value using XmlDocument

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related