Getting data from xml by attribute vlaue

Question

I have a file with the following content (myfile.xml). I have to get all content coming under (including product node) a product with id=1.

<products>  
  <product id="1">
       <category>q</category>  
  </product>    
  <product id="2">      
       <category>w</category>    
  </product>   
  <product id="3">       
  <category>e</category>   
 </product>
</products>`

i.e. the result should be :

 <product id="1"> 
      <category>q</category>
  </product>

How can I do this?

follow-up [using Xmltextreader](http://stackoverflow.com/questions/10680553/getting-data-from-xml-by-attribute-value-c-sharp-using-xmltextreader) — Nikana Reklawyks, Oct 05 '12 at 08:10

score 1 · Answer 1 · answered May 16 '12 at 15:46

1

using XPath in Linq

var root = XElement.Load("myfile.xml");  
root.XPathSelectElements( "/products/product[@id=1]");

answered May 16 '12 at 15:46

Tilak

30,108
19
83
131

score 0 · Accepted Answer · answered May 16 '12 at 12:07

0

var root = XElement.Load("path to the file");
var node = root.Descendants("product").FirstOrDefault(e=>e.Attribute("id").Value == "1");

answered May 16 '12 at 12:07

RePierre

9,358
2
20
37

Getting data from xml by attribute vlaue

2 Answers2

Linked