Simple question, how to do XPath search by XmlDocument with namesp

[Tommy]

For a XML fragment like below
<ns0:BusCar_Request xmlns:ns0="http://BTSDG_SQL">
<ns0:sync>
<ns0:after>
<ns0:BusinessCards NameOnCard="NameOnCard_1"
TitleOnCard="TitleOnCard_1" Quantity="10" />
<ns0:BusinessCards NameOnCard="NameOnCard_2"
TitleOnCard="TitleOnCard_2" Quantity="10" />
<ns0:BusinessCards NameOnCard="NameOnCard_3"
TitleOnCard="TitleOnCard_3" Quantity="10" />
</ns0:after>
</ns0:sync>
</ns0:BusCar_Request>
How to use XmlDocument and XPathNavigator (preferable) to do XPath query to
get the element with 'TitleOnCard' value equals to 'TitleOnCard_3'
Thanks in advance.

[Pascal Schmitt]

Hello!

How to use XmlDocument and XPathNavigator (preferable) to do XPath query to
get the element with 'TitleOnCard' value equals to 'TitleOnCard_3'
Thanks in advance.

You need to Compile the XPath-String into an XPathExpression and assign
an XmlNamespaceManager to its context (untested):

XPathExpression ex = doc.Compile("/a:BusCar_Request/b:something");
XmlNamespaceManager mgr = new XmlNamespaceManager( doc.NameTable );
mgr.AddNamespacePrefix( "a", "urn:foo:a" );
mgr.AddNamespacePrefix( "b", "urn:foo:b" );
ex.Context = mgr;

doc.Evaluate( ex );

--
Pascal Schmitt

[Tommy]

For the XML segment
"<ns0:BusCar_Request xmlns:ns0="http://BTSDG_SQL">
<ns0:sync>
<ns0:after>
<ns0:BusinessCards NameOnCard="NameOnCard_1"
TitleOnCard="TitleOnCard_1" Quantity="10" />
<ns0:BusinessCards NameOnCard="NameOnCard_2"
TitleOnCard="TitleOnCard_2" Quantity="10" />
<ns0:BusinessCards NameOnCard="NameOnCard_3"
TitleOnCard="TitleOnCard_3" Quantity="10" />
</ns0:after>
</ns0:sync>
</ns0:BusCar_Request>
"

I wrote the following code to get the suitable 'ns0:BusinessCards' element,
but everytime the compile return type returns boolean, could you help please

XPathDocument doc=new XPathDocument(dataFile);
XPathNavigator navigator=doc.CreateNavigator();

XmlNamespaceManager nsmgr= new XmlNamespaceManager(navigator.NameTable);
nsmgr.AddNamespace("ns0",@"http://BTSDG_SQL");
XPathExpression
exp=navigator.Compile(@"//BusinessCards/@TitleOnCard='TitleOnCard_3'");
exp.SetContext(nsmgr);
Console.WriteLine(exp.ReturnType);

"Pascal Schmitt" wrote:

Hello!

How to use XmlDocument and XPathNavigator (preferable) to do XPath query to
get the element with 'TitleOnCard' value equals to 'TitleOnCard_3'
Thanks in advance.

You need to Compile the XPath-String into an XPathExpression and assign
an XmlNamespaceManager to its context (untested):

XPathExpression ex = doc.Compile("/a:BusCar_Request/b:something");
XmlNamespaceManager mgr = new XmlNamespaceManager( doc.NameTable );
mgr.AddNamespacePrefix( "a", "urn:foo:a" );
mgr.AddNamespacePrefix( "b", "urn:foo:b" );
ex.Context = mgr;

doc.Evaluate( ex );

--
Pascal Schmitt

[Pascal Schmitt]

Hello!

XmlNamespaceManager nsmgr= new XmlNamespaceManager(navigator.NameTable);
nsmgr.AddNamespace("ns0",@"http://BTSDG_SQL");
XPathExpression
exp=navigator.Compile(@"//BusinessCards/@TitleOnCard='TitleOnCard_3'");

You also have to use the Namespace prefix you registered in your expression:

exp=navigator.Compile(@"//ns0:BusinessCards/@TitleOnCard='TitleOnCard_3'");
--------------------------^^^
--
Pascal schmitt

[Tommy]

I modified the code as belows:

XmlNamespaceManager nsmgr= new XmlNamespaceManager(navigator.NameTable);
nsmgr.AddNamespace("ns0",@"http://BTSDG_SQL");
XPathExpression
exp=navigator.Compile(@"//ns0:BusinessCards/@TitleOnCard='TitleOnCard_3'");
exp.SetContext(nsmgr);
Console.WriteLine(exp.ReturnType);

Still, everytime it says boolean, I am expecting a nodeset returned. Please
help, thanks a lot !!!

"Pascal Schmitt" wrote:

Hello!

XmlNamespaceManager nsmgr= new XmlNamespaceManager(navigator.NameTable);
nsmgr.AddNamespace("ns0",@"http://BTSDG_SQL");
XPathExpression
exp=navigator.Compile(@"//BusinessCards/@TitleOnCard='TitleOnCard_3'");

You also have to use the Namespace prefix you registered in your expression:

exp=navigator.Compile(@"//ns0:BusinessCards/@TitleOnCard='TitleOnCard_3'");
--------------------------^^^
--
Pascal schmitt

[Martin Honnen]

Tommy wrote:

exp=navigator.Compile(@"//ns0:BusinessCards/@TitleOnCard='TitleOnCard_3'"); Still, everytime it says boolean, I am expecting a nodeset returned.

I think you want an XPath expression alike
//ns0:BusinessCards[@TitleOnCard='TitleOnCard_3']
then to have a nodeset returned.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Tommy]

Oh, my ! what a stupid mistake I made. Thanks a lot for your help, Martin.

"Martin Honnen" wrote:

Tommy wrote:

exp=navigator.Compile(@"//ns0:BusinessCards/@TitleOnCard='TitleOnCard_3'");

Still, everytime it says boolean, I am expecting a nodeset returned.

I think you want an XPath expression alike
//ns0:BusinessCards[@TitleOnCard='TitleOnCard_3']
then to have a nodeset returned.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/