C# reading xml inside certain node

Question

I need help. I'm trying to figure out a way to read inside a bracket like this one:

<group id = "56"> 
<name>Counter</name> 
</group>

In the code, there are mulitiple places where the same pattern comes back, and I would like to get all the group id number's and their name.

This is my code:

        XDocument doc = XDocument.Parse(_XmlFile);
        var results = doc.Descendants("group").Select(x => new
        {
            id = (int)x.Attribute("id"),
            name = x.Attribute("name").Value,
        }).ToList();

        Console.WriteLine(results);

Thanks

1. You cant cast XElement to int. You need to parse the Value which is a string. 2. name is not an attribute but a child element to group. — Sani Huttunen
– Sani Huttunen, Commented May 3, 2017 at 17:42
@SLaks: Indeed it does. My Bad... :) Well... It's actually XAttribute in this case... Which does not inherit from XNode... But XAttribute has the same cast operators as well... — Sani Huttunen
– Sani Huttunen, Commented May 3, 2017 at 17:53

derpirscher · Accepted Answer · 2017-05-03 18:00:04Z

1

Your code looks quite OK, but name is an element and not an attribute, so it should be

XDocument doc = XDocument.Parse(_XmlFile);
var results = doc.Descendants("group").Select(x => new
{
    id = (int)x.Attribute("id"),
    name = (string)x.Element("name"),
}).ToList();

foreach (var x in results)
    Console.WriteLine("id: {0}   name: {1}", x.id, x.name);

edited May 3, 2017 at 18:00

answered May 3, 2017 at 17:44

derpirscher

17.7k3 gold badges25 silver badges54 bronze badges

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

Comments

Ivo Kazimirs · Accepted Answer · 2017-05-03 17:44:50Z

0

Use GetElementsByTagName method.

Here is the microsoft article explaining it with examples. https://msdn.microsoft.com/en-us/library/dc0c9ekk(v=vs.110).aspx

answered May 3, 2017 at 17:44

Ivo Kazimirs

317 bronze badges

1 Comment

Mikael Sauriol Saad Over a year ago

If i use that, once I put group in the doc.GetElementsByTagName("group"), It returns all the rest of the xml.

Dávid Molnár · Accepted Answer · 2017-05-03 17:54:09Z

0

"Name" is not an attribute, but a child node. The solution is something like this:

XDocument doc = XDocument.Parse(_XmlFile);
var results = doc.Descendants("group").Select(x => new
{
    id = int.Parse(x.Attribute("id").Value),
    name = x.Descendants("name").First().Value
}).ToList();

answered May 3, 2017 at 17:54

Dávid Molnár

11.7k7 gold badges33 silver badges60 bronze badges

2 Comments

derpirscher Over a year ago

You don't need the int.Parse part, but you can cast the XAttribute to int and x.Element("name") is the more accurate way to for getting the first child element of an XElement. Furthermore x.Descendants gets the children in all descendent levels. Maybe this is not desired. And if there is no descendant name your code will throw an exception

Dávid Molnár Over a year ago

Thanks, you'r right. I did no see your answer before posting... :)

Collectives™ on Stack Overflow

C# reading xml inside certain node

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related