XML problems

supergirl_gem · July 2nd, 2007, 06:41 AM

Hi can anyone help me I'm currently trying to use a rss feed from the yahoo weather site and manipulate it.

The issue i have is with the prefixes:

<rss version="2.0" xmlns:yweather="http://xml.weather.yahoo.com/ns/rss/1.0" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#">
<channel>
....
<item>
...
<yweather:condition text="Mostly Cloudy" code="28" temp="15" date="Mon, 02 Jul 2007 8:50 am BST" />
</item>
</channel>
</rss>0

I'm having difficulty accessing the attributes within the yweather:conditon tag. Currently trying to use asp.net, can't seem to get to this tag or it's attributes.

Can anyone help? I would appreciate it, thanks in advance.

Gemma

joefawcett · July 2nd, 2007, 07:59 AM

Can you show what you have tried? There is help on accessing namespaced elements in the first post in this forum. If you need to bind prefixes to namespace URIs you either need to declare them on the XSLT or by using the NamespaceManager, depending on how you are working with the data.

--

Joe (Microsoft MVP - XML)

supergirl_gem · July 2nd, 2007, 09:28 AM

protected void Page_Load(object sender, EventArgs e)
    {
        XmlDocument doc = new XmlDocument();
        XmlNodeList nodeList;

        doc.Load("rss.xml");

        //Create an XmlNamespaceManager for resolving namespaces.
        XmlNamespaceManager nsmgr = new XmlNamespaceManager(doc.NameTable);
        nsmgr.AddNamespace("yweather", "urn:samples");

        nodeList = doc.SelectNodes("/rss/channel/item/yweather:condition", nsmgr);

        foreach (XmlNode node in nodeList)
        {

            Response.Write(node.InnerText + "<br>");

        }
    }

if i use the above code, nothing is outputted, but if i remove the /yweather:condition then it does output. any ideas?

thanks

joefawcett · July 2nd, 2007, 09:43 AM

Well yweather is mapped to http://xml.weather.yahoo.com/ns/rss/1.0 in the XML, not urn:samples.

--

Joe (Microsoft MVP - XML)

supergirl_gem · July 2nd, 2007, 09:50 AM

that doesn't seem to make any difference???

joefawcett · July 2nd, 2007, 11:03 AM

Sorry but that should work, what code do you have now? Can you also post the rss XML so that I can see tthe structure more clearly?

--

Joe (Microsoft MVP - XML)

supergirl_gem · July 2nd, 2007, 12:03 PM

ok, it seems to be working but how do i output at particular attribute?

thanks

Gemma

joefawcett · July 3rd, 2007, 01:56 AM

Code:

foreach (XmlNode node in nodeList)
{
  XmlElement weather = node as XmlElement;
  string description = weather.GetAttribute("text");
  Response.Write(description);          
}

--

Joe (Microsoft MVP - XML)