RSS Feed in ASP.NET

Introduction

This article describes how to create a RSS feed in ASP.Net.

Procedure

To create a RSS feed use the following procedure:

1. Add the following line in to the RSS page under the page directive line as in the following:
   

   1. <%@OutputCacheDuration="120"VaryByParam="*"%>

2. Create a table with the fields Id, title, description and URL and enter some dummy data like:
   
   
   

3. Add the following code on the page load:

   1. string connectionString = "Data Source=name;Initial Catalog=db name;Integrated Security=True";
   2. DataTable d_t = newDataTable();
   3. SqlConnection conn = newSqlConnection(connectionString);
   4. using (conn)
   5. {
   6. SqlDataAdapter adp = newSqlDataAdapter("SELECT * from tablename", conn);
   7. adp.Fill(d_t);
   8. }
   9. Response.Clear();
   10. Response.ContentType = "text/xml";
   11. XmlTextWriter Text_Writer = newXmlTextWriter(Response.OutputStream,Encoding.UTF8);
   12. Text_Writer.WriteStartDocument();
   13. //Below tags are mandatory rss
   14. Text_Writer.WriteStartElement("rss");
   15. Text_Writer.WriteAttributeString("version","2.0");
   16. // Channel tag will contain RSS feed details
   17. Text_Writer.WriteStartElement("channel");
   18. Text_Writer.WriteElementString("title"," ASP.NET ");
   19. Text_Writer.WriteElementString("link","http://nehaprogrammer.blogspot.com");
   20. Text_Writer.WriteElementString("description"," C#.NET,ASP.NET ");
   21. Text_Writer.WriteElementString("copyright","Copyright 2013 - 2014 nehaprogrammer.blogspot.com. All rights reserved.");
   22. foreach (DataRow oFeedItem in d_t.Rows)
   23. {
   24. Text_Writer.WriteStartElement("item");
   25. Text_Writer.WriteElementString("title", oFeedItem["Title"].ToString());
   26. Text_Writer.WriteElementString("description", oFeedItem["Description"].ToString());
   27. Text_Writer.WriteElementString("link", oFeedItem["URL"].ToString());
   28. Text_Writer.WriteEndElement();
   29. }
   30. Text_Writer.WriteEndElement();
   31. Text_Writer.WriteEndElement();
   32. Text_Writer.WriteEndDocument();
   33. Text_Writer.Flush();
   34. Text_Writer.Close();
   35. Response.End();

Save all and view the page in the browser. It will work perfectly.