Problem with SQL Server bulk load XML def
XML / XSL
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I'm loading an XML file generated by SQL Server 2005 and trying to locate certain nodes: Dim d As New Xml.XmlDocument d.Load(path) If I use the following: Dim lst As Xml.XmlNodeList = d.SelectNodes("//COLUMN") then "lst" contains 0 nodes, If I use this one instead: Dim lst As Xml.XmlNodeList = d.GetElementsByTagName("COLUMN") then "lst" is correctly filled. Am I missing something important on XPath, XML...???? Or is it a VB.Net issue? I don't think it's a .Net problem, because that very same code works on other xml files (with different tags).