XPath string to select a specific node with specific value c#

Question

I want to select a node where inner text of cat is 'PG' using XPath

<?xml version="1.0" encoding="utf-8"?>
<Students>
    <student>
        <name>Talha</name>
        <cat>PG</cat>
    </student>
    <student>
        <name>irfan</name>
        <cat>UG</cat>
    </student>
    <student>
        <name>Ali</name>
        <cat>PG</cat>
    </student>
    <student>
        <name>Umer</name>
        <cat>UG</cat>
    </student>
</Students>

Code which I tried is this

XmlElement xmldoc = (XmlElement)doc.DocumentElement
    .SelectSingleNode("/Students/student/*[*[local-name()='cat']='PG']");

What's with the local-name() call? That's suspicious. You don't need that unless your actual XML has namespaces, and even then you don't really need it. So... does your actual XML have namespaces? If yes, show your actual XML. If not, get rid of local-name(). — Tomalak
– Tomalak, Commented Dec 21, 2017 at 20:15

zx485 · Accepted Answer · 2017-12-21 20:27:36Z

1

To select all the student nodes which sub-elements cat have the value 'PG' use this XPath expression

/Students/student[cat='PG']

To only get the first one use

/Students/student[cat='PG'][1]

So in the syntax of C# use

XmlElement xmldoc = (XmlElement)doc.DocumentElement.SelectSingleNode("/Students/student[cat='PG'][1]");

answered Dec 21, 2017 at 20:27

zx485

29.1k28 gold badges55 silver badges65 bronze badges

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

2 Comments

Thomas Weller Over a year ago

SelectSingleNode will only select a single node. No need for [1], right?

zx485 Over a year ago

@ThomasWeller: Yes. I only added that to emphasize that it's the first node of the two to be selected.

Collectives™ on Stack Overflow

XPath string to select a specific node with specific value c#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related