A1VBCode Forums / Visual Basic .NET / .NET Programming / Xpath query on an XML returns 0 results / Latest Posts

RE: Xpath query on an XML returns 0 results

spelltox — Mon, 14 Nov 2011 01:16:40 GMT

I'm getting the strangest feeling ... like maybe talking to myself ...

Anyhow - for someone else that might use this post, her'e the solution :

Should be :

nsMgr.AddNamespace("ns", "http://www.w3.org/1999/xhtml")

Instead of :

nsMgr.AddNamespace("http://www.w3.org/1999/xhtml", "ns")

RE: Xpath query on an XML returns 0 results

spelltox — Sun, 13 Nov 2011 16:45:43 GMT

So i've searched the net and found something that looks like a solution,
i've changed my code to :

[CODE]
Dim doc As New System.Xml.XmlDocument()
doc.Load("products.xml")

Dim root As System.Xml.XmlElement = doc.DocumentElement

Dim nsMgr As XmlNamespaceManager = New XmlNamespaceManager(root.OwnerDocument.NameTable)
nsMgr.AddNamespace("http://www.w3.org/1999/xhtml", "ns")
nodeList = root.SelectNodes("descendant::ns:div[@class='itemInfo']", nsMgr)

Console.WriteLine(nodes.Count)

For Each node As System.Xml.XmlNode In nodes
Dim name As String = node("name").InnerText
Dim title As String = node("title").InnerText
Console.Write("name" & vbTab & "{0}" & vbTab & "title" & vbTab & "{1}", name, title)
Next
[/CODE]

But now i'm getting an error :"Namespace prefix 'ns' is not defined."

RE: Xpath query on an XML returns 0 results

spelltox — Sun, 13 Nov 2011 16:24:18 GMT

The problem seems to be with the tag attribute :

 html xmlns="http://www.w3.org/1999/xhtml"

As soon as i removed the xmlns attribute my "selectNodes" method started working ...

So now -
Is there a way to still make it working without removing that xmlns attribute ?

Xpath query on an XML returns 0 results

spelltox — Sun, 13 Nov 2011 15:08:55 GMT

Hi guys !

A little something i hope you could help me with -

I've converted an html to XML and now i want to get all the child nodes nested
within a DIV element with a specific attribute (class="itemInfo").

Because the html that the XML is based on changes from time to time i want to use a more "safe" relative root,
(something like : "//div[@class='itemInfo']").

Problem is that i always get 0 nodes ...
I'm sure that something is wrong with my Xpath syntax, just don't know what it is.

Here is my code, please, any help would be appreciated.

[CODE]
Dim doc As New System.Xml.XmlDocument()
doc.Load("products.xml")

Dim root As System.Xml.XmlElement = doc.DocumentElement

Dim nodes As System.Xml.XmlNodeList = root.SelectNodes("//descendant::div[@class='itemInfo']")

Console.WriteLine(nodes.Count) '<-- always get 0

For Each node As System.Xml.XmlNode In nodes
Dim name As String = node("name").InnerText
Dim title As String = node("title").InnerText
Console.Write("name" & vbTab & "{0}" & vbTab & "title" & vbTab & "{1}", name, title)
Next
[/CODE]

I also tried :

root.SelectNodes("//div[@class='itemInfo']")

and :

root.SelectNodes("/*//div[@class='itemInfo']")

but nothing seems to work.

Thanks in advance !