get xml node value from id attribute c#

Question

I have a login page where the user chooses their name from a dropdown list then enters their id code in a text box. The page then redirects to the account page where the user's information is displayed. The dropdown list and the text box are being loaded and checked against an xml file, here's an example from it.

<staff>
<idcode>0200</idcode>
<Name id="0200">Doe, John</Name>
</staff>

I want the account page to check for the id attribute in the Name node to display the user's name in a label. I've tried using the method described here: C# Linq to XML query, but the output to the label I get is this "System.Linq.Enumerable+WhereEnumerableIterator`1[System.Xml.Linq.XElement]". Here's my code:

XDocument xdoc = XDocument.Load(Server.MapPath("Staff.xml"));
            var result = xdoc.Descendants("Staff").Elements("Name").Where(n => n.Attribute("id").Value == inputPassword);
        nameLabel.Text = result.ToString();

inputPassword is the idcode from the previous page and that loads correctly.

Am I missing something simple or would it be easier to restructure the xml so that the Name node is a child of the idcode node? Thanks.

Sergey Berezovskiy · Accepted Answer · 2014-05-13 15:54:06Z

2

If you need to select name by given id, then you need two more things - select only one element from result, and get value of this name element:

string name = xdoc.Descendants("Staff")
                  .Elements("Name")
                  .Where(n => (string)n.Attribute("id") == inputPassword)
                  .Select(n => (string)n) // get element's value
                  .FirstOrDefault();      // select only first value, if any

Or with XPath

string xpath = String.Format("//Staff/Name[@id='{0}']", inputPassword);
string name = (string)xdoc.XPathSelectElement(xpath);

answered May 13, 2014 at 15:54

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Comments

reggaeguitar · Accepted Answer · 2014-05-13 15:50:48Z

0

LINQ queries return iterators, to resolve it you need to add another method call, like Single() or ToList(). Try adding a Single() to the end of the call

XDocument xdoc = XDocument.Load(Server.MapPath("Staff.xml"));
            var result = xdoc.Descendants("Staff").Elements("Name").Where(n => n.Attribute("id").Value == inputPassword).Single();
        nameLabel.Text = result.ToString();

You could also use SingleOrDefault() to avoid a NRE

answered May 13, 2014 at 15:50

reggaeguitar

1,8141 gold badge29 silver badges48 bronze badges

Comments

pedrommuller · Accepted Answer · 2014-05-13 15:52:48Z

0

If you want to get the idcode I'd try something like this:

XDocument xdoc = XDocument.Load(Server.MapPath("Staff.xml"));
var result = xdoc.Descendants("Staff").Elements("idcode").Where(n => n.Value.ToString() == inputPassword).SingleOrDefault();
nameLabel.Text = result.ToString();

answered May 13, 2014 at 15:52

pedrommuller

16.1k11 gold badges82 silver badges139 bronze badges

Collectives™ on Stack Overflow

get xml node value from id attribute c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related