≡ Menu

How to fetch data form Rss

This is some code I used to fetch data from rss links  and insert to database.  Where _RssAgent is containing business logic, having getters, setters and function to insertion in database. you can implement as your requirement 

XmlDocument doc = new XmlDocument();
doc.Load(xmlPath);
//Get all Items in the XML file
//Get reference to the first author node in the XML file
XmlNodeList titleList = doc.GetElementsByTagName(“item”);
// loop for all get
for (int _Count = 0; _Count <= titleList.Count – 1; _Count++)
{
XmlNode authorNode = doc.GetElementsByTagName(“item”)[_Count];
_RssAgent = new clsBlogPost();
foreach (XmlNode child in authorNode.ChildNodes)
{
if ((child.Name == “title”) && (child.NodeType == XmlNodeType.Element))
{

// Assign Title of post to some variable
_RssAgent.PostTitle = child.FirstChild.Value;
}
if ((child.Name == “description”) && (child.NodeType == XmlNodeType.Element))
{

// assign the description of rss item to variable
_RssAgent.Content = child.FirstChild.Value;
}
if ((child.Name == “link”) && (child.NodeType == XmlNodeType.Element))
{
_RssAgent.PostUrl = child.FirstChild.Value;
}
if ((child.Name == “pubDate”) && (child.NodeType == XmlNodeType.Element))
{

//if pub date found then assign it to date
_RssAgent.PostedDate = Convert.ToDateTime(child.FirstChild.Value);
}
}
if (_RssAgent.PostedDate == Convert.ToDateTime(“1/1/0001”))
{
_RssAgent.PostedDate = Convert.ToDateTime(“1/1/1900”);
}
_RssAgent.DateIndexed = DateTime.Now;
_RssAgent.BlogId = _RssId;

///insertion method call you can use ur own code here
_RssAgent.Insert(_RssAgent);
}

{ 0 comments… add one }

Leave a Comment