How to select an attribute in XML based on the value of another attribute?

Question

Currently I am able to select attributes in an XML document because they are uniquely identifiable, like this:

XmlDocument weatherData = new XmlDocument();
weatherData.Load(query);

XmlNode channel = weatherData.SelectSingleNode("rss").SelectSingleNode("channel");
XmlNamespaceManager man = new XmlNamespaceManager(weatherData.NameTable);
man.AddNamespace("yweather", "http://xml.weather.yahoo.com/ns/rss/1.0");

town            = channel.SelectSingleNode("yweather:location", man).Attributes["city"].Value;

But how do I select the "text" attribute from a node of the same name (yweather:forecast)?

<yweather:forecast day="Sat" text="Sunny" code="32"/>
<yweather:forecast day="Sun" text="Partly Cloudy" code="30"/>
<yweather:forecast day="Mon" text="AM Showers" code="39"/>
<yweather:forecast day="Tue" text="Cloudy" code="26"/>
<yweather:forecast day="Wed" text="Cloudy/Wind" code="24"/>

Is there a conditional statement I can use to only select the text attribute where the day attribute is equal to "Mon"?

"yweather:location[@day = 'mon']/@city"

jessehouwing
– jessehouwing

2015-01-24 12:18:19 +00:00
Commented Jan 24, 2015 at 12:18 — jessehouwing
– jessehouwing, Commented Jan 24, 2015 at 12:18

Community · Accepted Answer · 2017-05-23 12:20:35Z

1

Something like this will work:

string xml = "YourXml";
XElement doc = XElement.Parse(xml);

var Result = from a in doc.Descendants("yweather:forecast")
             where a.Attribute("day").Value == "Mon"
             select a.Attribute("text").Value;

or lambda syntax:

var Result = doc.Descendants("yweather:forecast")
                .Where(x=> x.Attribute("day").Value == "Mon")
                .Select(x=> x.Attribute("text").Value);

you can also refer this SO post

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Jan 24, 2015 at 13:39

Ehsan Sajjad

62.6k16 gold badges112 silver badges171 bronze badges

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

Collectives™ on Stack Overflow

How to select an attribute in XML based on the value of another attribute?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related