How to get value of some object in XML string in C#?

Question

I have this XML String :

<RESPONSE>
    <SINGLE>
        <KEY name="sitename">
            <VALUE>Stackoverflow</VALUE>
        </KEY>
        <KEY name="username">
            <VALUE>this value</VALUE>
        </KEY>
    </SINGLE>
</RESPONSE>

How to get value from Key that name "username" ? I want to get value of "this value" in my code. I try deserialized and any other code but it doesnt work. Please help me, thanks :D

Edit:

I tried using this code :

XDocument doc = XDocument.Load( "myXML.xml" );

var keys = doc.Descendants( "KEY" );

foreach ( var VALUE in keys )
{
    Console.WriteLine( VALUE.Value );
}

But how did I get the Value only from KEY that named "Username" ? Thanks :))

take a look at this answer stackoverflow.com/questions/7119806/… — Jay
– Jay, Commented Apr 15, 2014 at 12:27
Normally you will try to get a Value from a concrete Key, in this case your are doing the opposite... — Alberto León
– Alberto León, Commented Apr 15, 2014 at 12:27
I tried using this stackoverflow.com/questions/14722492/… and this stackoverflow.com/questions/3187444/… code but it doesnt work. I confuse because i must get an object inside of Value inside of Key inside of Single. How ? :" — user2565280
– user2565280, Commented Apr 15, 2014 at 12:28

drew_w · Accepted Answer · 2014-04-15 12:37:43Z

3

You can probably use an xpath to do this. The following is an example XPath that will provide a node with name matching "sitename":

//KEY[@name="sitename"]

You can modify this slightly to find all nodes with a "name" attribute or to just find specific names. For more examples of how to use XPath see the MSDN site for XPath. The following is a snippet of C# code that shows you how to use this XPath (again, you can generalize for whatever XPath you need):

const string example_xml = "<RESPONSE> <SINGLE> <KEY name=\"sitename\"> <VALUE>Stackoverflow</VALUE> </KEY> <KEY name=\"username\"> <VALUE>this value</VALUE> </KEY> </SINGLE> </RESPONSE>";

// load
XmlDocument doc = new XmlDocument();
doc.LoadXml(example_xml);

// Query single or multiple nodes using the XPath, do what you want with this node!
var desiredNode = doc.SelectSingleNode("//KEY[@name=\"sitename\"]");

Best of luck!

edited Apr 15, 2014 at 12:37

answered Apr 15, 2014 at 12:30

drew_w

10.5k4 gold badges32 silver badges50 bronze badges

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

Comments

Nathan · Accepted Answer · 2014-04-15 13:05:27Z

1

For completeness here is a System.Xml.Linq version, with the foreachs and where's being System.Linq for good measure. This basically the questioner's attempt, with a where to filter according to attribute.

const string example_xml = "<RESPONSE> <SINGLE> <KEY name=\"sitename\"> <VALUE>Stackoverflow</VALUE> </KEY> <KEY name=\"username\"> <VALUE>this value</VALUE> </KEY> </SINGLE> </RESPONSE>";

XDocument doc = XDocument.Parse(example_xml);
var keys = doc.Descendants("KEY");
var userKeys = keys.Where(item => item.Attribute("name").Value == "username").ToList();
userKeys.ForEach(item => Console.WriteLine(item.Value));

edited Apr 15, 2014 at 13:05

answered Apr 15, 2014 at 12:58

Nathan

6,5614 gold badges45 silver badges81 bronze badges

1 Comment

Nathan Over a year ago

Sorry drew_w, I was lazy and nicked your string.

Darin Kolev · Accepted Answer · 2014-04-15 13:00:04Z

0

Lets consider your xml document as XYZ.xml, then you may try below code if you are using C#, below is the example only

       XmlDocument Doc = new XmlDocument();
        Doc.Load(Server.MapPath(".../xyz.xml"));
         XmlNodeList itemList = Doc.DocumentElement.SelectNodes("KEY");
         foreach (XmlNode currNode in itemList)
         {
             string name = string.Empty; 
             XmlNode item = currNode.SelectSingleNode("KEY");
             if(currNode["name"].InnerText == "username")//if you are aware of key name, use this       condition
             {
               name = item.Attributes["name"].Value.ToString(); // or currNode["name"].InnerText;
             }
          }

edited Apr 15, 2014 at 13:00

Darin Kolev

3,40913 gold badges34 silver badges48 bronze badges

answered Apr 15, 2014 at 12:43

user3535888

413 bronze badges

Collectives™ on Stack Overflow

How to get value of some object in XML string in C#?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related