StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POC# XPath help - Expression not working
primarykey
Id
4728409
data
AcceptedAnswerId
4728740
AnswerCount
4
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2011-01-18T19:56:58.420
FavoriteCount
1
LastActivityDate
2011-01-18T20:54:37.630
LastEditDate
2011-01-18T20:05:49.707
LastEditorUserId
273723
OwnerUserId
273723
ParentId
0
PostTypeId
1
Score
6
ViewCount
2908
LastEditorDisplayName
text
Body
Here is an example XML doc that matches the one I am getting info from: <pre><code><?xml version="1.0" standalone="yes"?> <Products xmlns="http://tempuri.org/Products.xsd"> <Movies> <Title>Title1</Title> <Language>English</Language> </Movies> <Movies> <Title>Title2</Title> <Language>English</Language> </Movies> <Movies> <Title>Title3</Title> <Language>French</Language> </Movies> <Books> <Title>BTitle1</Title> <Genre>Suspense</Genre> </Books> <Books> <Title>BTitle2</Title> <Genre>Suspense</Genre> </Books> <Books> <Title>BTitle3</Title> <Genre>SciFi</Genre> </Books> <Books> <Title>BTitle4</Title> <Genre>SciFi</Genre> </Books> </Products> </code></pre> Here is my code to get all books with the genre of Suspense: <pre><code>//Get state list using XPath XPathDocument xDoc = new XPathDocument(xmlPath); //Path to my file XPathNavigator xNav = xDoc.CreateNavigator(); string booksQuery = "Books[Genre = \"Suspense\"]"; XPathNodeIterator xIter = xNav.Select(booksQuery); while (xIter.MoveNext()) { //do stuff with xIter.Current } </code></pre> I have tried several queries including <code>Products/Books[Genre = \"Suspense\"]</code>, <code>Products/Books</code>, <code>./Books</code>, and <code>Books</code>. My xIter always has zero items. I'm new to XPath, so I'm sure it's a really simple error, but maybe not. I know I can get a DataSet with the tables [Movies] and [Books] out of this XML file using <code>myDataSet.ReadXml(myXmlPathString);</code> so the XML file is not corrupt. If that helps any. So, my question ... what am I doing wrong?
Tags
<c#><xml><xpath>
Title
C# XPath help - Expression not working
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMike Webb
UserOwnerUserId
1. USMike Webb
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POC# XPath help - Expression not working
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POC# XPath help - Expression not working
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POC# XPath help - Expression not working
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.