xpath query for finding an element with a condition which matches the attribute and child node value

xml xpath selectsinglenode
anamik picture anamik · Apr 19, 2011 · Viewed 20.4k times · Source

I have 2 elements with same attribute but with different child node values. Can I query to find a specific element which matches the attribute and also the child node value. To be specific, this is the sample xml i am using to query(each element in original xml has more than 10 childe nodes).

 <Book size="2">
  <Title>abc</Title>
  <Price>10</Price>
 </Book>
 <Book size="2">
  <Title>xyz</Title>
  <Price>20</Price>
 </Book>
 <Book size="4">
  <Title>Harry</Title>
  <Price>10</Price>
 </Book>

So, now I want to find the Book element which has the @size = "2" and Title = xyz.

Is this possible by using SelectSingleNode method? If not how to query this?

Thanks

Answer

Wayne picture Wayne · Apr 20, 2011

This:

//Book[@size='2'][Title='xyz']

Or this:

//Book[@size='2' and Title='xyz']

Note that the use of // is discouraged when your schema is known.

Related questions

Using SelectSingleNode with XPath returns NULL

I trying to modify an XML file with SelectSingleNode. The structure of file is <?xml version="1.0" encoding="utf-8"?> <Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <ProjectExtensions> <Borland.Personality>Delphi.Personality</…

Read More
SelectNodes with XPath ignoring cases in node names

I have a problem similar to the question SelectNodes with XPath ignoring cases but in my case the uppercase/lowercase problem is in the node with the name 'application' (Sometimes is 'Application' other times 'application'). How would i apply the …

Read More
System.Xml.XPath.XPathException: Expression must evaluate to a node-set when executing SelectSingleNode("//(artist|author)")

Can somebody explain me why is this not working? I'm executing XmlNode xmlNode = xmlDocument.SelectSingleNode("//(artist|author)"); and I get System.Xml.XPath.XPathException: Expression must evaluate to a node-set. but this works and does not raise the exception even …

Read More