Querying with an XML document

[George L Jackson]

Mike, Your query won't work. Since you know the country you can find the 'Country' child node of the parent (which happens to be 'Country' too), and, then, you can access its sibling 'Continent' node: //Country[Country='Afghanistan']/Continent

[vinusk]

Thanks Mike, Will try out the solution you have suggested. Is there anyway I can do this using XMLTextReader... Regards, Vinu

[led mike]

George L. Jackson wrote:

Your query won't work.

It worked when I ran it. Is that what you mean?

led mike

[led mike]

vinusk wrote:

can do this using XMLTextReader...

I have not used XMLTextReader much so I do not know, but typically if you are going to query XML you use a DOM and SelectNodes(). I would normally use XmlDocument for that.

led mike

[led mike]

Here is another

//Country[CNo = '?']/Continent/text()

XPath is pretty nice eh? :-D I always run these before I post them.

led mike

[George L Jackson]

:-> My bad! Your code didn't seem correct to me. I am sorry.

[led mike]

George L. Jackson wrote:

Your code didn't seem correct to me.

No sweat. It never seems right to me that's why I always run it. :laugh:

led mike

[George L Jackson]

If you are using .NET Framework 1.1, it is XmlTextReader. If you are using .NET Framework 2.0, it is XmlReader. Anyway, you query differently with XmlTextReader/XmlReader since it uses a pull technique. However, you can get the same results but you have to do more coding. http://www.codeproject.com/useritems/XmlTextReader.asp[^]

[vinusk]

Thanks Mike and George. I will try it out and revert back. With warm regards, Vinu

[vinusk]

Thanks got it working.:)