Xpath in c#

[DBC User]

Hi,

I have an xml and I am able to use xpath to identify each node that
statisfy the selection criteria. I got the node list. I would like to
know is it possible to do the following for the following XML
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

I have lot of application and I want to find out only the ones with
'one' I got that working got the nodelist. Inside the iterator, I want
to get the values of Version and age and assign it to a class. But I do
not want to hard code something like

myClass.Version = node.ChildNodes[0].InnerText;
myClass.Age = node.ChildNodes[1].InnerText;

it works, but I would like to get it based on a element name, that
gives me the flexibility incase some adds a element in between version
or age. Or they rearrange the xml node itself.

Hope I am clear. Please let me know how can I do this in the best
possible approach? (I was thinking of applying XPath on each node to
get it, just worried the performance and resource)

Thanks.

[sloan]

Something like this. (Going from memory).

The indexer has an string argument. (see string theVersion below)

http://msdn2.microsoft.com/en-us/lib...t_members.aspx

<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

XmlNode nodeServer = // get a XmlNode somehow, usually the .SelectSingleNo de
method

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
string currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ;
}
"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi,

I have an xml and I am able to use xpath to identify each node that
statisfy the selection criteria. I got the node list. I would like to
know is it possible to do the following for the following XML
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

I have lot of application and I want to find out only the ones with
'one' I got that working got the nodelist. Inside the iterator, I want
to get the values of Version and age and assign it to a class. But I do
not want to hard code something like

myClass.Version = node.ChildNodes[0].InnerText;
myClass.Age = node.ChildNodes[1].InnerText;

it works, but I would like to get it based on a element name, that
gives me the flexibility incase some adds a element in between version
or age. Or they rearrange the xml node itself.

Hope I am clear. Please let me know how can I do this in the best
possible approach? (I was thinking of applying XPath on each node to
get it, just worried the performance and resource)

Thanks.

[Michael]

*"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
* Hi,
*
* I have an xml and I am able to use xpath to identify each node that
* statisfy the selection criteria. I got the node list. I would like to
* know is it possible to do the following for the following XML
* <Files>
* <Application key="one">
* <Version>1</Version>
* <Age>120</Age>
* </Application>
* </Files>
*
* I have lot of application and I want to find out only the ones with
* 'one' I got that working got the nodelist. Inside the iterator, I want
* to get the values of Version and age and assign it to a class. But I do
* not want to hard code something like
*
* myClass.Version = node.ChildNodes[0].InnerText;
* myClass.Age = node.ChildNodes[1].InnerText;
*
* it works, but I would like to get it based on a element name, that
* gives me the flexibility incase some adds a element in between version
* or age. Or they rearrange the xml node itself.
*
* Hope I am clear. Please let me know how can I do this in the best
* possible approach? (I was thinking of applying XPath on each node to
* get it, just worried the performance and resource)
*
* Thanks.
*

DBC User,

The XmlNode (System.Xml.Xml Node) class' indexer does accept a string
argument for accessing child Elements.
Could you not try something like

myClass.Version = node["Version"].InnerText;
myClass.Age = node["Age"].InnerText;
--MH
,

[DBC User]

Hi Micheal,

I get a nodelist from selectnodes and then I am traversing through
XmlNode. But for some reason it looks like
for(XmlNode node in nodelist)
{
....
}
node is still in Nodelist and it takes only integer. Thats what
bothering me. Even though I did a casting it still error out as
XML.XmlNodeList . here is the code

XmlNodeList list = doc.SelectNodes (@"/Files/Application[@year=2005]");
foreach(XmlNode node in list)
{
string t = node.ChildNodes["Version"].InnerText;
...
}

this fails during compile time with 'Best overload method is
System.Xml.XmlN odeList.this[int]'

Any idea??

Thanks.

Michael wrote:

*"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
* Hi,
*
* I have an xml and I am able to use xpath to identify each node that
* statisfy the selection criteria. I got the node list. I would like to
* know is it possible to do the following for the following XML
* <Files>
* <Application key="one">
* <Version>1</Version>
* <Age>120</Age>
* </Application>
* </Files>
*
* I have lot of application and I want to find out only the ones with
* 'one' I got that working got the nodelist. Inside the iterator, I want
* to get the values of Version and age and assign it to a class. But I do
* not want to hard code something like
*
* myClass.Version = node.ChildNodes[0].InnerText;
* myClass.Age = node.ChildNodes[1].InnerText;
*
* it works, but I would like to get it based on a element name, that
* gives me the flexibility incase some adds a element in between version
* or age. Or they rearrange the xml node itself.
*
* Hope I am clear. Please let me know how can I do this in the best
* possible approach? (I was thinking of applying XPath on each node to
* get it, just worried the performance and resource)
*
* Thanks.
*

DBC User,

The XmlNode (System.Xml.Xml Node) class' indexer does accept a string
argument for accessing child Elements.
Could you not try something like

myClass.Version = node["Version"].InnerText;
myClass.Age = node["Age"].InnerText;
--MH
,

[DBC User]

Hi Sloan,

Only problem I have is I do selectnodes not select single node so I end
up getting xmlnodelist rather than xmlnode and in xmlnodelist I can not
use key. Only available way is to use integer. So the question now is
How do I convert a xmlnodelist to xmlnode? I will do some research and
see if I can find it.

Thanks.
sloan wrote:

Something like this. (Going from memory).

The indexer has an string argument. (see string theVersion below)

http://msdn2.microsoft.com/en-us/lib...t_members.aspx

<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

XmlNode nodeServer = // get a XmlNode somehow, usually the .SelectSingleNo de
method

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
string currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ;
}
"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi,

I have an xml and I am able to use xpath to identify each node that
statisfy the selection criteria. I got the node list. I would like to
know is it possible to do the following for the following XML
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

I have lot of application and I want to find out only the ones with
'one' I got that working got the nodelist. Inside the iterator, I want
to get the values of Version and age and assign it to a class. But I do
not want to hard code something like

myClass.Version = node.ChildNodes[0].InnerText;
myClass.Age = node.ChildNodes[1].InnerText;

it works, but I would like to get it based on a element name, that
gives me the flexibility incase some adds a element in between version
or age. Or they rearrange the xml node itself.

Hope I am clear. Please let me know how can I do this in the best
possible approach? (I was thinking of applying XPath on each node to
get it, just worried the performance and resource)

Thanks.

[DBC User]

Following solution works but as I said in the first part isit right way
to do it?

XmlNode t1 = node.SelectSing leNode("Version ");
string t = t1.InnerText;

DBC User wrote:

Hi Sloan,

Only problem I have is I do selectnodes not select single node so I end
up getting xmlnodelist rather than xmlnode and in xmlnodelist I can not
use key. Only available way is to use integer. So the question now is
How do I convert a xmlnodelist to xmlnode? I will do some research and
see if I can find it.

Thanks.
sloan wrote:

Something like this. (Going from memory).

The indexer has an string argument. (see string theVersion below)

http://msdn2.microsoft.com/en-us/lib...t_members.aspx

<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

XmlNode nodeServer = // get a XmlNode somehow, usually the .SelectSingleNo de
method

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
string currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ;
}
"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi,
>
I have an xml and I am able to use xpath to identify each node that
statisfy the selection criteria. I got the node list. I would like to
know is it possible to do the following for the following XML
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>
>
I have lot of application and I want to find out only the ones with
'one' I got that working got the nodelist. Inside the iterator, I want
to get the values of Version and age and assign it to a class. But I do
not want to hard code something like
>
myClass.Version = node.ChildNodes[0].InnerText;
myClass.Age = node.ChildNodes[1].InnerText;
>
it works, but I would like to get it based on a element name, that
gives me the flexibility incase some adds a element in between version
or age. Or they rearrange the xml node itself.
>
Hope I am clear. Please let me know how can I do this in the best
possible approach? (I was thinking of applying XPath on each node to
get it, just worried the performance and resource)
>
Thanks.
>

[sloan]

..SelectSingleN ode is basically a short cut,,, to just get the first match.

SelectNodes gives you a list of nodes. Usually you iterate over them if you
get a list.
foreach (XmlNode nodeServer in nodeListServers )
{

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ; // NOT
..ChildNodes as you have in another post. INDEXER.
}

}

"DBC User" <db*****@gmail. comwrote in message
news:11******** *************@7 4g2000cwt.googl egroups.com...

Hi Sloan,

Only problem I have is I do selectnodes not select single node so I end
up getting xmlnodelist rather than xmlnode and in xmlnodelist I can not
use key. Only available way is to use integer. So the question now is
How do I convert a xmlnodelist to xmlnode? I will do some research and
see if I can find it.

Thanks.
sloan wrote:

Something like this. (Going from memory).

The indexer has an string argument. (see string theVersion below)

http://msdn2.microsoft.com/en-us/lib...t_members.aspx

<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

XmlNode nodeServer = // get a XmlNode somehow, usually the

..SelectSingleN ode

method

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
string currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ;
}
"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi,
>
I have an xml and I am able to use xpath to identify each node that
statisfy the selection criteria. I got the node list. I would like to
know is it possible to do the following for the following XML
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>
>
I have lot of application and I want to find out only the ones with
'one' I got that working got the nodelist. Inside the iterator, I want
to get the values of Version and age and assign it to a class. But I

do

not want to hard code something like
>
myClass.Version = node.ChildNodes[0].InnerText;
myClass.Age = node.ChildNodes[1].InnerText;
>
it works, but I would like to get it based on a element name, that
gives me the flexibility incase some adds a element in between version
or age. Or they rearrange the xml node itself.
>
Hope I am clear. Please let me know how can I do this in the best
possible approach? (I was thinking of applying XPath on each node to
get it, just worried the performance and resource)
>
Thanks.
>

[Michael]

***"DBC User" <db*****@gmail. comwrote in message
*** news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
*** Hi,
***
*** I have an xml and I am able to use xpath to identify each node that
*** statisfy the selection criteria. I got the node list. I would like to
*** know is it possible to do the following for the following XML
*** <Files>
*** <Application key="one">
*** <Version>1</Version>
*** <Age>120</Age>
*** </Application>
*** </Files>
***
*** I have lot of application and I want to find out only the ones with
** * 'one' I got that working got the nodelist. Inside the iterator, I want
*** to get the values of Version and age and assign it to a class. But I do
*** not want to hard code something like
** *
*** myClass.Version = node.ChildNodes[0].InnerText;
** * myClass.Age = node.ChildNodes[1].InnerText;
***
** * it works, but I would like to get it based on a element name, that
*** gives me the flexibility incase some adds a element in between version
*** or age. Or they rearrange the xml node itself.
***
*** Hope I am clear. Please let me know how can I do this in the best
*** possible approach? (I was thinking of applying XPath on each node to
*** get it, just worried the performance and resource)
** *
*** Thanks.
***
***
** DBC User,
**
** The XmlNode (System.Xml.Xml Node) class' indexer does accept a string
** argument for accessing child Elements.
** Could you not try something like
**
** myClass.Version = node["Version"].InnerText;
** myClass.Age = node["Age"].InnerText;
**
**
** --MH
** ,
**
*"DBC User" <db*****@gmail. comwrote in message
news:11******** *************@7 4g2000cwt.googl egroups.com...
* Hi Micheal,
*
* I get a nodelist from selectnodes and then I am traversing through
* XmlNode. But for some reason it looks like
* for(XmlNode node in nodelist)
* {
* ...
* }
* node is still in Nodelist and it takes only integer. Thats what
* bothering me. Even though I did a casting it still error out as
* XML.XmlNodeList . here is the code
*
* XmlNodeList list = doc.SelectNodes (@"/Files/Application[@year=2005]");
* foreach(XmlNode node in list)
* {
* string t = node.ChildNodes["Version"].InnerText;
* ...
* }
*
* this fails during compile time with 'Best overload method is
* System.Xml.XmlN odeList.this[int]'
*
* Any idea??
*
* Thanks.
*

DBC User,

Within your foreach loop structure, node is of type System.Xml.XmlN ode
so calling the ChildNotes property returns an System.Xml.XmlN odeList as
you've mentioned.
We don't want an XmlNodeList here if we're to try using the XmlNode class'
indexer.
We want an XmlNode which is what your loop scope variable "node" is.
So, You may try altering the line

string t = node.ChildNodes["Version"].InnerText;

into this

string t = node["Version"].InnerText;
-MH

[DBC User]

Thanks all I think I got it, it is not the childnodes, it is the
indexer.

sloan wrote:

.SelectSingleNo de is basically a short cut,,, to just get the first match.

SelectNodes gives you a list of nodes. Usually you iterate over them if you
get a list.
foreach (XmlNode nodeServer in nodeListServers )
{

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ; // NOT
.ChildNodes as you have in another post. INDEXER.
}

}

"DBC User" <db*****@gmail. comwrote in message
news:11******** *************@7 4g2000cwt.googl egroups.com...

Hi Sloan,

Only problem I have is I do selectnodes not select single node so I end
up getting xmlnodelist rather than xmlnode and in xmlnodelist I can not
use key. Only available way is to use integer. So the question now is
How do I convert a xmlnodelist to xmlnode? I will do some research and
see if I can find it.

Thanks.
sloan wrote:

Something like this. (Going from memory).
>
The indexer has an string argument. (see string theVersion below)
>
>
>
>

http://msdn2.microsoft.com/en-us/lib...t_members.aspx

>
>
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>
>
>
XmlNode nodeServer = // get a XmlNode somehow, usually the

.SelectSingleNo de

method
>
string currentXpath = "key";
>
if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
>
>
string currentXpath = "Version";
>
if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ;
}
>
>
"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
Hi,

I have an xml and I am able to use xpath to identify each node that
statisfy the selection criteria. I got the node list. I would like to
know is it possible to do the following for the following XML
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>

I have lot of application and I want to find out only the ones with
'one' I got that working got the nodelist. Inside the iterator, I want
to get the values of Version and age and assign it to a class. But I

do

not want to hard code something like

myClass.Version = node.ChildNodes[0].InnerText;
myClass.Age = node.ChildNodes[1].InnerText;

it works, but I would like to get it based on a element name, that
gives me the flexibility incase some adds a element in between version
or age. Or they rearrange the xml node itself.

Hope I am clear. Please let me know how can I do this in the best
possible approach? (I was thinking of applying XPath on each node to
get it, just worried the performance and resource)

Thanks.

[sloan]

Ding Ding Ding !

Yeah, the indexer is a little tricky, esp if you come from VB.NET where it
uses the .Item(N) property.

Remember that if you code up your own indexer, you can overload it.

this[int personid]
this[string lastname]

...


"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m79g2000cwm.goo glegroups.com.. .

Thanks all I think I got it, it is not the childnodes, it is the
indexer.

sloan wrote:

.SelectSingleNo de is basically a short cut,,, to just get the first

match.

SelectNodes gives you a list of nodes. Usually you iterate over them if

you

get a list.
foreach (XmlNode nodeServer in nodeListServers )
{

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}
currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ; // NOT
.ChildNodes as you have in another post. INDEXER.
}

}

"DBC User" <db*****@gmail. comwrote in message
news:11******** *************@7 4g2000cwt.googl egroups.com...

Hi Sloan,
>
Only problem I have is I do selectnodes not select single node so I

end

up getting xmlnodelist rather than xmlnode and in xmlnodelist I can

not

use key. Only available way is to use integer. So the question now is
How do I convert a xmlnodelist to xmlnode? I will do some research and
see if I can find it.
>
Thanks.
sloan wrote:
Something like this. (Going from memory).

The indexer has an string argument. (see string theVersion below)

http://msdn2.microsoft.com/en-us/lib...t_members.aspx

<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>


XmlNode nodeServer = // get a XmlNode somehow, usually the

.SelectSingleNo de

method

string currentXpath = "key";

if (null!=nodeServ er.Attributes[currentXpath])
{
string theKey = nodeServer.Attr ibutes[currentXpath].Value ;
}


string currentXpath = "Version";

if (null!=nodeServ er[currentXpath])
{
string theVersion = nodeServer[currentXpath].Value ;
}


"DBC User" <db*****@gmail. comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .
Hi,
>
I have an xml and I am able to use xpath to identify each node

that

statisfy the selection criteria. I got the node list. I would like

to

know is it possible to do the following for the following XML
<Files>
<Application key="one">
<Version>1</Version>
<Age>120</Age>
</Application>
</Files>
>
I have lot of application and I want to find out only the ones

with

'one' I got that working got the nodelist. Inside the iterator, I

want

to get the values of Version and age and assign it to a class. But

I

do

not want to hard code something like
>
myClass.Version = node.ChildNodes[0].InnerText;
myClass.Age = node.ChildNodes[1].InnerText;
>
it works, but I would like to get it based on a element name, that
gives me the flexibility incase some adds a element in between

version

or age. Or they rearrange the xml node itself.
>
Hope I am clear. Please let me know how can I do this in the best
possible approach? (I was thinking of applying XPath on each node

to

get it, just worried the performance and resource)
>
Thanks.
>
>