SelectSingleNode with XmlDataDocument

[H Irick]

I have code that worked with an XMLDocument. Now I'm trying to convert it to use with a synchronized XML dataset loaded from my database. The only difference I can see is that the DataDocument constructer has added an xmlns attribute to the parent tag

I find that xDoc.GetElementsByTagName works fine, but xDoc.SelectSingleNode and xDoc.SelectNodes both return Nothing, even when there are clearly child nodes matching the request. The XML was created from a loaded dataset with nested relations. Here is my code. xNode is Nothing after the SelectSingleNode statement

Any help will be appreciated

Public Sub Add(ByVal xMfgNode As System.Xml.XmlNode
Dim sName As Strin
oMfg = New Manufacture
Dim xNode As XmlNod

xNode = xMfgNode.SelectSingleNode("mfgcode"

sName = xNode.Valu
oMfg.Name = sNam
oMfg.LoadMakers(xMfgNode, sName
oMfg.LoadProducts(xMfgNode, sName
mcolManufacturer.Add(oMfg
miCount = miCount +
oMfg = Nothin
End Su

This is the OuterXML of xMfgNode

<mfg xmlns="http://tempuri.org/Dataset1.xsd"><mfgId>1</mfgId><mfgcode>Paints</mfgcode><maker><makerId>2</makerId><mfgId>1</mfgId><makercode>Paints</makercode><product><productID>3</productID><makerId>2</makerId><proddesc>Blue</proddesc></product><product><productID>4</productID><makerId>2</makerId><proddesc>Green</proddesc></product></maker></mfg>

[Oleg Tkachenko [MVP]]

H Irick wrote:

I find that xDoc.GetElementsByTagName works fine, but xDoc.SelectSingleNode and xDoc.SelectNodes both return Nothing, even when there are clearly child nodes matching the request. The XML was created from a loaded dataset with nested relations. Here is my code. xNode is Nothing after the SelectSingleNode statement.

It's a faq. Read about default namespace and XPath and take a look at
SelectSingleNode(string, XmlNamespaceManager) method documentation at MSDN.

--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com