How to retrieve XML data using XPath Expression

Question

I have a XMLDataSource somewhat like:

<bookstore>
  <author>author1</author>
  <publication>publication1</publication>
  <book>
    <genre>Thriller</genre>
    <name>ABC</name>
  </book>
  <book>
    <genre>Romance</genre>
    <name>XYZ</name>
  </book>
  <book>
    <genre>Horror</genre>
    <name>000</name>
  </book>
</bookstore>

I am storing these in a asp:formview. I am able to store author and publication values but not sure how can I store the value of book/name based on some condition? Actually I just want to use condition that I need to store the value of "name" if "genere=Romance". something like this. I tried using XPath expression bookstore/book/genre[. ='Romance'] but not sure how to access the value of tag. Checked the following resource:

http://msdn.microsoft.com/en-us/library/ms256086.aspx

Appreciate if someone can help me.

user357812 · Accepted Answer · 2010-10-19 13:37:57Z

2

I tried using XPath expression bookstore/book/genre[. ='Romance'] but not sure how to access the value of tag

Almost. This XPath expression:

/bookstore/book[genre='Romance']/name

String value: XYZ

answered Oct 19, 2010 at 13:37

user357812

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

Comments

Michael Shopsin · Accepted Answer · 2010-10-19 13:34:35Z

0

You probably need to add /text() to get the contents of the XML tag instead of just the tag. There is a great XML cheat-sheet here that should help you.

answered Oct 19, 2010 at 13:34

Michael Shopsin

2,1482 gold badges27 silver badges47 bronze badges

Collectives™ on Stack Overflow

How to retrieve XML data using XPath Expression

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related