Converting RSS feed into DataTable

Question

Hi i am reading the RSS feed and creating an XML using the DataTable. This is my code

  try
            {
                DataTable tbl = new DataTable();
                tbl.Columns.Add("id");
                tbl.Columns.Add("product_name");
                tbl.Columns.Add("description");

                //Extra Nodes
                tbl.Columns.Add("brand");
                tbl.Columns.Add("condition");
                tbl.Columns.Add("product_type");

                        XmlDocument doc = new XmlDocument();
                        XmlDocument xmlDoc = new XmlDocument();
                        xmlDoc.Load(s);
                        XmlNodeList itemNodes = xmlDoc.SelectNodes("//rss/channel/item");
                        foreach (XmlNode itemNode in itemNodes)
                        {
                            DataRow row = tbl.NewRow();
                            XmlNode idNode = itemNode.SelectSingleNode("id");
                            XmlNode product_nameNode = itemNode.SelectSingleNode("product_name");
                            XmlNode descriptionNode = itemNode.SelectSingleNode("description");

                            //extra nodes
                            XmlNode brandNode = itemNode.SelectSingleNode("brand");
                            XmlNode conditionNode = itemNode.SelectSingleNode("condition");
                            XmlNode product_typeNode = itemNode.SelectSingleNode("product_type");



                            if (idNode != null && product_nameNode != null && descriptionNode != null )
                            {
                                row[0] = idNode.InnerText;
                                row[1] = product_nameNode.InnerText;
                                row[2] = descriptionNode.InnerText;

                                //extra nodes
                                if (brandNode == null)
                                    row[3] = "";
                                else
                                    row[3] = brandNode.InnerText;

                                if (conditionNode==null)
                                    row[4] = "";
                                else
                                    row[4] = conditionNode.InnerText;

                                if (product_typeNode==null)
                                    row[5] = "";
                                else
                                    row[5] = product_typeNode.InnerText;

                                                          }
                            tbl.Rows.Add(row);
                            // tbl.Rows.Add(row);
                        }

                }
            }
            catch (Exception ex)
            {
               // Console.WriteLine(ex.Message);
               // Console.Read();

            }

This is working fine without any issue but i want to make my code more efficient. Is this the good way to read the Rss and add into the datatable ? I am making a SSIS project on VS 2008 so i can not use SyndicationFeed .

Have a look here http://stackoverflow.com/questions/10399400/best-way-to-read-rss-feed-in-net-using-c-sharp — Crowcoder, Feb 04 '15 at 01:25

score 2 · Accepted Answer · answered Feb 04 '15 at 02:32

You can use this code below ans use as example.

using System;
using System.ServiceModel.Syndication;
using System.Xml;

namespace RSSFeed
{
    public class Program
    {
        static void Main(string[] args)
        {
            // URL from the site you need (RSS Feed in XML please).
            String url = "http://www.medicalnewstoday.com/rss/abortion.xml";

            // Create XML Reader.
            using (XmlReader xmlReader = XmlReader.Create(url, new XmlReaderSettings() { DtdProcessing = DtdProcessing.Ignore }))
            {
                // Load The Feed.
                SyndicationFeed syndicationFeed = SyndicationFeed.Load(xmlReader);

                // through the list.
                foreach (SyndicationItem item in syndicationFeed.Items)
                {
                    // You can use a lot of information here todo what you need.
                    // TODO...

                    // Examples
                    String subject = item.Title.Text;
                    String summary = item.Summary.Text;
                }

                xmlReader.Close();
            }
        }
    }
}

Thanks but i can not use SyndicationFeed on SSIS 2008 project @Diego — user3754676, Feb 04 '15 at 03:06

Converting RSS feed into DataTable

1 Answers1