CODEWITHSUNDEEP
c#xml
NULL
NULL

Reputation: 1589

create list from xml file c#

I am getting this rss feeds and i am trying to get the data of the rss feed to a list format so that my customers can search through the data.

this is the ONLY way that worked for this kind of xml data:

xmlFile.SelectNodes("//ns:id |//ns:title | //ns:description", xmlnm);

public void MyMain(string[] args)
{
    WebRequest request = WebRequest.Create("url to xml file");
    WebResponse response = request.GetResponse();
    Stream dataStream = response.GetResponseStream();
    XmlDocument xmlDocument = new XmlDocument();
    xmlDocument.Load(dataStream);
    XmlNamespaceManager xmlnm = new XmlNamespaceManager(xmlDocument.NameTable);
    xmlnm.AddNamespace("ns", "http://www.w3.org/2005/Atom");

    ParseXML(xmlDocument, xmlnm);

    MessageBox.Show("\n---XML parsed---");
    //Console.ReadKey();
}

public void ParseXML(XmlDocument xmlFile, XmlNamespaceManager xmlnm)
{
    //this commented section WORKS FANTASTIC!!
    /* XmlNodeList nodes = xmlFile.SelectNodes("//ns:id |//ns:title | //ns:description", xmlnm);;
    foreach (XmlNode node in nodes)
    {
        MessageBox.Show(node.Name + " = " + node.InnerXml);
    }
    */

    //SO i decided to store the xml data into a list, and nothing works below. I have a created a simple RSSXML class to store the information
    XmlNodeList nodes = xmlFile.SelectNodes("//ns:id |//ns:title | //ns:description", xmlnm);
    List<RSSXML> items = new List<RSSXML>();           
    foreach (XmlNode node in nodes)
    {
        items.Select(x => new RSSXML()
        {
            id = node.InnerXml,
            title = node.InnerXml,
            description = node.InnerXml,
            //can add more fields here
        }).ToList();             

    }
    foreach (var myitems in items)
    {
        MessageBox.Show(myitems.summary.ToString());
    }
}

public class RSSXML()
{
//simple get set methods for id, title, description, etc
}

Upvotes: 0

Views: 3207

Answers (1)

Henk Holterman
Henk Holterman

Reputation: 273244

items.Select() produces a new List, you are not storing it.

The basic fix:

XmlNodeList nodes = xmlFile.SelectNodes("//ns:id |//ns:title | //ns:description", xmlnm);
List<RSSXML> items = new List<RSSXML>();           
foreach (XmlNode node in nodes)
{
    //items.Select(x => new RSSXML()
    items.Add(new RSSXML {
    {
        id = node.InnerXml,
        title = node.InnerXml,
        description = node.InnerXml,
        //can add more fields here
    //}).ToList();             
    });
}

You could eliminate the foreach() :

XmlNodeList nodes = xmlFile.SelectNodes("//ns:id |//ns:title | //ns:description", xmlnm);
List<RSSXML> items = nodes.Select(n => new RSSXML()
    {
        id = n.InnerXml,
        title = n.InnerXml,
        description = n.InnerXml,
        //can add more fields here
    }).ToList();

And you probably want to replace .InnerXml with just .Value.

Upvotes: 2

Related Questions