In this Article, I will show you, How to create Rss feeds for your website article. Rss feed is a xml file so in this article, i will create a XML file and Data pick from database table. Rss contains differenet filds link channel , article title, article description, link of the article and many more things. By using Rss feeds we can improve our search engine results , i mean to say we can improve our SEO of the website.
How to Start it: First of all create two table in the database, These are the fields which are mentioned below. If you are the beginners then i will provide you a short video through this you can create both table easily.
Also i will provide you scripts of table, through these you can directly create table into your database.
CREATE TABLE [dbo].[Channel] (
CREATE TABLE [dbo].[Channel] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Title] NVARCHAR (100) NULL,
[Description] NVARCHAR (MAX) NULL,
[Link] NVARCHAR (100) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
CREATE TABLE [dbo].[Feeds] (
[Id] UNIQUEIDENTIFIER NOT NULL,
[ChannelID] INT IDENTITY (1, 1) NOT NULL,
[Title] NVARCHAR (100) NULL,
[Description] NVARCHAR (MAX) NULL,
[Link] NVARCHAR (100) NULL,
[PDate] NVARCHAR (100) NULL,
PRIMARY KEY CLUSTERED ([ChannelID] ASC)
);
Add a Generic handler file, In it you have a ProcessRequest method. In This method you have to create your logic , I mean to say put your business logic code. You can copy the mentioned code and paste into your Generic Handler file.
<%@ WebHandler Language="C#" Class="Handler" %>
using System;
using System.Web;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
public class Handler : IHttpHandler {
public void ProcessRequest (HttpContext context) {
createFeed(context, 1);
}
private void createFeed(HttpContext context,int chnlID)
{
using (XmlTextWriter writer=new XmlTextWriter(context.Response.OutputStream,System.Text.Encoding.UTF8))
{
DataTable dtable = GetTable("select * from [Channel] where Id=@channelID", chnlID);
writer.WriteStartDocument();
writer.WriteStartElement("Rss");
writer.WriteAttributeString("version", "1.0");
writer.WriteStartElement("Channel");
writer.WriteElementString("Title", dtable.Rows[0]["Title"].ToString());
writer.WriteElementString("Description", dtable.Rows[0]["Description"].ToString());
writer.WriteElementString("Link", dtable.Rows[0]["Link"].ToString());
//writer.WriteElementString("Title", dtable.Rows[0]["Title"].ToString());
dtable = GetTable("select * from [Feeds] where ChannelID= @channelID", chnlID);
foreach (DataRow item in dtable.Rows)
{
writer.WriteStartElement("Item");
writer.WriteElementString("Title", item["Title"].ToString());
writer.WriteElementString("Description", item["Description"].ToString());
writer.WriteElementString("Link", item["Link"].ToString());
writer.WriteElementString("Pub-Date", item["PDate"].ToString());
writer.WriteElementString("UniqueId",item["Id"].ToString());
writer.WriteEndElement();
}
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Flush();
writer.Close();
}
}
private DataTable GetTable(string qry,int chnlID)
{
DataTable dt=new DataTable();
SqlConnection con = new SqlConnection();
con.ConnectionString=@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand(qry, con);
cmd.Parameters.AddWithValue("@channelID", chnlID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return dt;
}
public bool IsReusable {
get {
return false;
}
}
}