Getting Attribute's value from xml in c#

Question

I have a LINQ expression which gets the XML attribute values from a xml file.

 var xml = XElement.Load(@"C:\\StoreServer1.xml");
 var query = from e in xml.Descendants("Groups")
             where int.Parse(e.Element("Store").Value) == 1500
             select e.Element("Store").Attribute("WeekDayStClose").Value;

And the xml file is:

enter<?xml version="1.0" encoding="utf-8" ?>
<Stores>
    <Groups Range="000"> 
        <Store WeekDayStClose="210" SatStClose="21" SunStClose="22">1500</Store>
        <Store WeekDayStClose="23" SatStClose="24" SunStClose="25">18</Store>
        <Store WeekDayStClose="23" SatStClose="24" SunStClose="25">19</Store>
    </Groups> 
</Stores>

I am only getting the attribute result (value) for first element of 1500. If I search same thing for 18 it doesn't return any result and no exception. Any help appreciated....Plz help!!!

Aditya Singh · Accepted Answer · 2013-12-23 17:28:26Z

1

Try this out:-

var xml = XElement.Load(@"C:\\StoreServer1.xml");
var query = xml.Descendants("Groups").Descendants("Store").Where(e => int.Parse(e.Value) == 18).Select(e=> e.Attribute("WeekDayStClose").Value);

answered Dec 23, 2013 at 17:28

Aditya Singh

9,6125 gold badges35 silver badges56 bronze badges

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

1 Comment

sakura-bloom Over a year ago

You used e.Element("Store") instead of Descendants("Store") because Element Gets the first (in document order) child element with the specified XName. (source: MSDN)

Yair Nevet · Accepted Answer · 2013-12-23 17:44:34Z

1

You should be more granular, call sub Descendants with Store (XName):

    var xml = XElement.Load(@"C:\\New Folder\\StoreServer1.xml");
    var query = from e in xml.Descendants("Groups").Descendants("Store")
                where int.Parse(e.Value) == 18
                select e.Attribute("WeekDayStClose").Value;

Because now you're retrieving only the first Store of each Group which is 1500.

edited Dec 23, 2013 at 17:44

answered Dec 23, 2013 at 17:26

Yair Nevet

13.1k17 gold badges71 silver badges111 bronze badges

Comments

Philip W · Accepted Answer · 2013-12-23 17:32:12Z

0

Yes, you have a little error in your code: You are splitting your xml into group-elements (you have just one group). Then you check if the first store element has the value 1500 (you are not checking if the following store elements have maybe the value 1500)

You need to change your code into the following

        var query = from e in xml.Descendants("Store")
                    where int.Parse(e.Value) == 1500
                    select e.Attribute("WeekDayStClose").Value;

answered Dec 23, 2013 at 17:32

Philip W

7913 silver badges7 bronze badges

2 Comments

Yair Nevet Over a year ago

There are only 1 Stores

Philip W Over a year ago

My mistake, i meant to write "Store"

Collectives™ on Stack Overflow

Getting Attribute's value from xml in c#

3 Answers 3

Try this out:-

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Try this out:-

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related