get xml node value from xml string

Question

I have xml which contain xml namespace. i need to get value from its xml node

<personxml:person xmlns:personxml="http://www.your.example.com/xml/person" xmlns:cityxml="http://www.my.example.com/xml/cities">
<personxml:name>Rob</personxml:name>
<personxml:age>37</personxml:age>
<cityxml:homecity>
    <cityxml:name>London</cityxml:name>
    <cityxml:lat>123.000</cityxml:lat>
    <cityxml:long>0.00</cityxml:long>
</cityxml:homecity>

Now i want to get value of tag <cityxml:lat> as 123.00

Code :

string xml = "<personxml:person xmlns:personxml='http://www.your.example.com/xml/person' xmlns:cityxml='http://www.my.example.com/xml/cities'><personxml:name>Rob</personxml:name><personxml:age>37</personxml:age><cityxml:homecity><cityxml:name>London</cityxml:name><cityxml:lat>123.000</cityxml:lat><cityxml:long>0.00</cityxml:long></cityxml:homecity></personxml:person>";
var elem = XElement.Parse(xml);
var value = elem.Element("OTA_personxml/cityxml:homecity").Value;

Error i am getting

The '/' character, hexadecimal value 0x2F, cannot be included in a name.

what about trying something like this elem.SelectSingleNode("/cityxml:homecity/@value").Value — MethodMan
– MethodMan, Commented Sep 10, 2014 at 14:52

Donal · Accepted Answer · 2014-09-10 15:03:21Z

1

You need to use XNamespace. For example:

XNamespace ns1 = "http://www.your.example.com/xml/person";
XNamespace ns2 = "http://www.my.example.com/xml/cities";

var elem = XElement.Parse(xml);
var value = elem.Element(ns2 + "homecity").Element(ns2 + "name").Value;

//value = "London"

Create XNamespace using a string that contains the URI, then combine the namespace with the local name.

For more information, see here.

edited Sep 10, 2014 at 15:03

answered Sep 10, 2014 at 14:56

Donal

33.2k10 gold badges69 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shaggy Over a year ago

how to get only name as London ?

Donal Over a year ago

@Shaggy var value = elem.Element(ns2 + "homecity").Element(ns2 + "name").Value;

Jeffrey Wieder · Accepted Answer · 2014-09-10 14:52:10Z

1

You are better off using a XmlDocument to navigate your xml.

        XmlDocument doc = new XmlDocument();
        doc.LoadXml(xml);
        XmlNode node = doc.SelectSingleNode("//cityxml:homecity/cityxml:lat");
        string latvalue = null;
        if (node != null) latvalue = node.InnerText;

answered Sep 10, 2014 at 14:52

Jeffrey Wieder

2,3841 gold badge16 silver badges12 bronze badges

Comments

Stephen Walker · Accepted Answer · 2014-09-10 15:08:41Z

1

The error I got with your code was that there needs to be a namespace to parse the XML properly Try :

 XNamespace ns1 = "http://www.your.example.com/xml/cities";
 string value = elem.Element(ns1 + "homecity").Element(ns1 + "name").Value;

I would still advice using XDocuments to parse if possible, but the above is fine if your way is a must.

edited Sep 10, 2014 at 15:08

answered Sep 10, 2014 at 15:00

Stephen Walker

5743 silver badges10 bronze badges

Collectives™ on Stack Overflow

get xml node value from xml string

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related