XML Get element based on attribute

Question

Can someone please help me. I'm new to XML and xElement. How can I get number of men where year = 2013? The result should be 300.

I have this XML:

<company>
  <department>
    <departmentname>Dep 1</departmentname>
    <year id = "2012">
      <men>200</men>
      <women>1000</women>
    </year>
    <year id = "2013">
      <men>300</men>
      <women>400</women>
    </year>
  </department>
</company>

I have this code (not working):

XElement company = XElement.Load(Server.MapPath(myXML.xml));
var men = (from a in company.Elements("department").Elements("year")
           where (string)a.Attribute("id").Value == "2013"
           select (string)(a.Element("men"))).ToList<string>();

what about other departments!

Anirudha
– Anirudha

2013-11-08 17:33:00 +00:00
Commented Nov 8, 2013 at 17:33 — Anirudha
– Anirudha, Commented Nov 8, 2013 at 17:33

Rubens Farias · Accepted Answer · 2013-11-08 19:14:02Z

1

What about using XPath?

var xmldoc = XDocument.Parse(@"<?xml version='1.0' encoding='utf-8'?>
    <company>
      <department>
        <departmentname>Dep 1</departmentname>
        <year id = '2012'>
          <men>200</men>
          <women>1000</women>
        </year>
        <year id = '2013'>
          <men>300</men>
          <women>400</women>
        </year>
      </department>
    </company>");

Console.WriteLine(
    xmldoc.XPathSelectElement(
            "/company/department/year[@id='2013']/men").Value);

answered Nov 8, 2013 at 19:14

Rubens Farias

58k8 gold badges136 silver badges165 bronze badges

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

Comments

Anirudha · Accepted Answer · 2013-11-08 17:49:17Z

0

Assuming you want it from all departments

int mens=company.Descendants("year")
                .Where(x=>x.Attribute("id").Value=="2013")
                .Sum(x=>int.Parse(x.Element("men").Value));

Your query should be

int men = (from a in company.Elements("department").Elements("year")
           where a.Attribute("id").Value == "2013"
           select int.Parse(a.Element("men").Value)).Sum();

edited Nov 8, 2013 at 17:49

answered Nov 8, 2013 at 17:29

Anirudha

32.9k8 gold badges71 silver badges90 bronze badges

3 Comments

user2939293 Over a year ago

I would prefer to use xElement the way I have started. How can I do this?

Anirudha Over a year ago

@user2939293 Works on my pc... your xml is not in proper format..Attributes values must be within ""

user2939293 Over a year ago

Yes, the values are within "" in the original file. I have changed it. Thank you

Ben · Accepted Answer · 2013-11-08 18:28:24Z

0

XElement company = XElement.Load(Server.MapPath(myXML.xml));

var txt = company.Descendants("men")
    .First(x => int.Parse(x.Parent.Attribute("id").Value) == 2013).Value;

Not very robust but will do the job in your case and you should get the idea.

And with LINQ syntax rather than extension method:

var txt =
    (from c in company.Descendants("men")
     where c.Parent.Attribute("id").Value == "2013"
     select c).First().Value;

edited Nov 8, 2013 at 18:28

answered Nov 8, 2013 at 17:33

Ben

1,96316 silver badges17 bronze badges

2 Comments

user2939293 Over a year ago

I would prefer to use xElement the way I have started. How can I do this?

Ben Over a year ago

The way you started? You mean using LINQ syntax rather than extension methods?

user2939293 · Accepted Answer · 2013-11-08 19:23:39Z

0

Ok guys. I used this and it's working Thank you for your help!

 XElement com = (from p in company.Elements("department")
                                    where (string)p.Element("departmentname").Value == "Dep 1"
                                    select p).First();



    var men= (from a in com.Elements("year")
                              where (string)a.Attribute("id") == "2013"
                              select (string)(a.Element("men"))).ToList<string>();

answered Nov 8, 2013 at 19:23

user2939293

8135 gold badges18 silver badges43 bronze badges

Collectives™ on Stack Overflow

XML Get element based on attribute

4 Answers 4

Comments

3 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related