Hi,
This is a newbie question to XMLNS. I just finished the article on "XML
Namespaces and How They Affect XPath and XSLT" by Dare Obasanjo and I'm
pretty sure I understand the problem. I just don't know how to achieve the
desired XPath result. I'm dealing with an XML document that has two XMLNS' in
the root node (Report) and I'm ending up with 0 results using SelectNodes. If
I take out both namespaces, the SelectNodes(XPa thQuery) works fine. With the
XMLNS' the SelectNodes(XPa thQuery, nsMgr) retrieves nothing. Here's a piece
of the XML doc and what I'm trying to do in code:
<?xml version="1.0"?>
<Report
xmlns="OESummar y_GTN"
xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance" Name="OESummary _GTN"
Summary="Summar y of Order Number 5K129"
Advertiser="Poi nt 360-Dallas"
Estimate="ESTIM ATE 123"
Bill_To="Bernie Customer"
Job_Number="454 5454" >
<list1>
<list1_Details_ Group Name="Audio (3)">
<table1>
<table1_Group1_ Collection>
<table1_Group 1 code="KARN-AM" city_state="Lit tle Rock,AR">
<table1_Details _Group_Collecti on>
<table1_Details _Group stationType="AM " status="Online" />
</table1_Details_ Group_Collectio n>
</table1_Group1>
<table2>
<table2_Details _Group_Collecti on>
<table2_Details _Group isci="TLPEP0009 R" title="THEY'RE OFF/W. FLA" />
<table2_Details _Group isci="TLPEP0003 R" title="THEY'RE OFF/CEN FLA" />
</table2_Details_ Group_Collectio n>
</table2>
</list1_Details_G roup>
<list1_Details_ Group Name="Video Foo"> ...
</list1_Details_G roup>
</list1>
</report>
I know.....it's a really ugly document but that's what I have to work with!
Here's the code:
Dim xmlDoc As New XmlDocument
Dim OrderNodes, ISCINodes, StationNodes As XmlNodeList
Dim OrderNode, ISCINode, StationNode As XmlNode
Dim fileXML As New FileStream("c:\ temp\XMLDoc.xml ", FileMode.Open)
xmlDoc.Load(fil eXML)
Dim nsMgr As XmlNamespaceMan ager = New XmlNamespaceMan ager(xmlDoc.Nam eTable)
nsMgr.AddNamesp ace("", "OESummary_GTN" )
nsMgr.AddNamesp ace("xsi", "http://www.w3.org/2001/XMLSchema-instance")
' Get Order Detail Packets
OrderNodes = xmlDoc.GetEleme ntsByTagName("l ist1_Details_Gr oup")
For Each OrderNode In OrderNodes
' Pull Out ISCI's from Order Detail Packet
ISCINodes = OrderNode.Selec tNodes
("table2/table2_Details_ Group_Collectio n/table2_Details_ Group", nsMgr)
' Pull Out Stations from Order Detail Packet
StationNodes = OrderNode.Selec tNodes
("table1/table1_Group1_C ollection/table1_Group1", nsMgr)
next
I pretty sure the issue is related to the nsMgr, but I'm in the weeds as to
what SelectNodes is looking for, since none of the nested nodes has a
namespace. I assume they inherit from the root node and that they inherit the
default namespace??
Thanks!
Linda
