Xpath Search with Namespaces

[NOSPAM.schnell]

I've run into a problem trying to search an XML document with a
namespace. Sample extract is below:

<Vendors xmlns="http://tempuri.org/Vendor.xsd">
<Vendor>
<VendorID>002010</VendorID>
<PropricerId>002010S</PropricerId>
<VendorName>AEROTEK, INC.</VendorName>
</Vendor>
<Vendor>
<VendorID>002012</VendorID>
<PropricerId>002012S</PropricerId>
<VendorName>ARONSON &amp; COMPANY</VendorName>
</Vendor>
<Vendor>
<VendorID>002018</VendorID>
<PropricerId>002018S</PropricerId>
<VendorName>ASSOCIATED SPRING RAYMOND</VendorName>
</Vendor>
I'm trying to get a VendorName based on a vendor ID. I'm using
Microsoft .Net framework XML parser.

I've tried numerous variations on the following:

..SelectSingleNode("//default:Vendor/default:VendorName[VendorID='008300'],
<<Variable indicating namespace>>)

TIA,

Michael Schnell

[swapna guddanti [MSFT]]

try the following:

..SelectSingleNode("a:Vendors/a:Vendor/a:VendorName[../a:VendorID='008300']")
where "a" maps to your namespace.

When you are using the predicate on VendorName, the context at that point is
inside the element VendorName, so you need to use the parent axis to access
VendorID like "../a:VendorID"

hope this helps,
swapna

"NO************@rdacorp.NOSPAM.com" <sc*****@rdacorp.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

I've run into a problem trying to search an XML document with a
namespace. Sample extract is below:

<Vendors xmlns="http://tempuri.org/Vendor.xsd">
<Vendor>
<VendorID>002010</VendorID>
<PropricerId>002010S</PropricerId>
<VendorName>AEROTEK, INC.</VendorName>
</Vendor>
<Vendor>
<VendorID>002012</VendorID>
<PropricerId>002012S</PropricerId>
<VendorName>ARONSON &amp; COMPANY</VendorName>
</Vendor>
<Vendor>
<VendorID>002018</VendorID>
<PropricerId>002018S</PropricerId>
<VendorName>ASSOCIATED SPRING RAYMOND</VendorName>
</Vendor>
I'm trying to get a VendorName based on a vendor ID. I'm using
Microsoft .Net framework XML parser.

I've tried numerous variations on the following:

.SelectSingleNode("//default:Vendor/default:VendorName[VendorID='008300'],
<<Variable indicating namespace>>)

TIA,

Michael Schnell

[Kevin Yu [MSFT]]

Hi Michael,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get the VendorName by
VendorID in an XmlDocument. If there is any misunderstanding, please feel
free to let me know.

According to the document you have provided, we cannot get the VendorName
directly using SelectSingleNode. Because the VendorID and VendorName is in
the same level of the document. However, we can get the parent Vendor node
with SelectSingleNode. Here is the code.

XmlDocument doc = new XmlDocument();
doc.LoadXml(XmlText);
XmlNamespaceManager nsm = new XmlNamespaceManager(doc.NameTable);
nsm.AddNamespace("default", "http://tempuri.org/Vendor.xsd");

XmlNode n =
doc.SelectSingleNode("//default:Vendor[default:VendorID='008300']", nsm);

Node n is the <Vendor> node. You can get the child <VendorName> element to
get the name.

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."