it can generate by code or by SQL with dataset create a new class naming it “RSS_Writer” and just copy and paste code below.
//LWEBCODE C# RSS 2.0 Atom FEED Writer Usage example:
//To generate a feed by code (in this case rss will placed into root directory of websites):
string RssPath = Server.MapPath("../rss.xml");
RSS_Writer.NewRss(RssPath, "FEED Title", "www.exmple.com", "Header Description of feed", "en-us");
//to add a items programmatically:
RSS_Writer.AddItems(RssPath, "your title", "link to this article", "Description", "");
//to generate rss from SQL after have filled a Dataset (ds) :
RSS_Writer.CreateRssFromDataSet(RssPath, ds, "titleFiled", "LnkField", "DescrField", "GuidField");
//Here C# LWEBCODE RSS 2.0 Atom FEED Writer Class
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml;
using System.IO;
/// RSS_Writer
/// generated by LWEBCODE
/// http://lwebcode.blogspot.com/
///
///
public class RSS_Writer
{
public RSS_Writer()
{
//string path = HttpContext.Current.Server.MapPath("rss.xml");
public static int NewRss(string path, string sTitle, string sLink, string sDescription, string sLanguage)
{
//XmlTextWriter writer = OpenXMLWriter(path);
/*writer.WriteStartDocument();
writer.WriteProcessingInstruction("xml-stylesheet", "type='text/xsl' href='lead.xsl'");
writer.WriteStartElement("rss");
writer.WriteAttributeString("version", "2.0");
writer.WriteStartElement("channel");
writer.WriteElementString("title", sTitle);
writer.WriteElementString("link", sLink);
writer.WriteElementString("description", sDescription);
writer.WriteElementString("language", sLanguage);
string GMTDate = System.TimeZone.CurrentTimeZone.ToUniversalTime(DateTime.Now).ToString("r");
writer.WriteElementString("lastBuildDate", GMTDate);
*/
XmlDocument xd = new XmlDocument();
//xd.Load(path);
XmlNode xn;
xn = xd.CreateNode(XmlNodeType.Element, "rss", null);
XmlAttribute xa;
xa = xd.CreateAttribute("version");
xa.Value = "2.0";
xn.Attributes.Append(xa);
xd.AppendChild(xn);
xn = xd.CreateNode(XmlNodeType.Element, "channel", null);
xd.SelectSingleNode("//rss").AppendChild(xn);
xn = xd.CreateNode(XmlNodeType.Element, "title", null);
xn.InnerText = sTitle;
xd.SelectSingleNode("//channel").AppendChild(xn);
xn = xd.CreateNode(XmlNodeType.Element, "link", null);
xn.InnerText = sLink;
xd.SelectSingleNode("//channel").InsertAfter(xn, xd.SelectSingleNode("//title"));
xn = xd.CreateNode(XmlNodeType.Element, "description", null);
xn.InnerText = sDescription;
xd.SelectSingleNode("//channel").InsertAfter(xn, xd.SelectSingleNode("//link"));
xn = xd.CreateNode(XmlNodeType.Element, "language", null);
xn.InnerText = sLanguage;
xd.SelectSingleNode("//channel").InsertAfter(xn, xd.SelectSingleNode("//description"));
string GMTDate = System.TimeZone.CurrentTimeZone.ToUniversalTime(DateTime.Now).ToString("r");
xn = xd.CreateNode(XmlNodeType.Element, "lastBuildDate", null);
xn.InnerText = GMTDate;
xd.SelectSingleNode("//channel").InsertAfter(xn, xd.SelectSingleNode("//language"));
XmlTextWriter writer = OpenXMLWriter(path, false);
xd.Save(writer);
CloseXMLWriter(writer);
return 0;
}
public static int AddItems(string path, string sTitle, string sLink, string sDescription, string sGuid)
{
UpdateRssHEAD(path);
XmlDocument xd = new XmlDocument();
xd.Load(path);
XmlNode xn = xd.CreateNode(XmlNodeType.Element, "item", null);
XmlNode xn2;
xn2 = xd.CreateNode(XmlNodeType.Element, "title", null);
xn2.InnerText = sTitle;
xn.AppendChild(xn2);
xn2 = xd.CreateNode(XmlNodeType.Element, "link", null);
xn2.InnerText = sLink;
xn.AppendChild(xn2);
xn2 = xd.CreateNode(XmlNodeType.Element, "description", null);
xn2.InnerText = sDescription;
xn.AppendChild(xn2);
string GMTDate = System.TimeZone.CurrentTimeZone.ToUniversalTime(DateTime.Now).ToString("r");
xn2 = xd.CreateNode(XmlNodeType.Element, "pubDate", null);
xn2.InnerText = GMTDate;
xn.AppendChild(xn2);
xn2 = xd.CreateNode(XmlNodeType.Element, "guid", null);
xn2.InnerText = sGuid;
xn.AppendChild(xn2);
xd.SelectSingleNode("//channel").InsertAfter(xn, xd.SelectSingleNode("//lastBuildDate"));
XmlTextWriter writer = OpenXMLWriter(path, false);
xd.Save(writer);
CloseXMLWriter(writer);
return 0;
}
public static int CreateRssFromDataSet(string path, DataSet ds, string sTitleField, string sLinkField, string sDescriptionField, string sGuidField)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
AddItems(path, ds.Tables[0].Rows[i][sTitleField].ToString(), ds.Tables[0].Rows[i][sLinkField].ToString(), ds.Tables[0].Rows[i][sDescriptionField].ToString(), ds.Tables[0].Rows[i][sGuidField].ToString());
}
return 0;
}
private static int UpdateRssHEAD(string path)
{
XmlDocument xd = new XmlDocument();
xd.Load(path);
XmlNode nodeCh = xd.DocumentElement.SelectSingleNode("//channel");
XmlNode xnd = xd.DocumentElement.SelectSingleNode("//lastBuildDate");
string GMTDate = System.TimeZone.CurrentTimeZone.ToUniversalTime(DateTime.Now).ToString("r");
xnd.InnerText = GMTDate;
nodeCh.ReplaceChild(xnd, xnd);
XmlTextWriter writer = OpenXMLWriter(path, false);
xd.Save(writer);
CloseXMLWriter(writer);
return 0;
}
private static XmlTextWriter OpenXMLWriter(string path)
{
XmlTextWriter writer;
if (!File.Exists(path))
{
writer = new XmlTextWriter(path, System.Text.Encoding.UTF8);
}
else
{
Stream xmlFile = new System.IO.FileStream(path, FileMode.Append);
writer = new XmlTextWriter(xmlFile, System.Text.Encoding.UTF8);
}
return writer;
}
private static XmlTextWriter OpenXMLWriter(string path, bool Append)
{
XmlTextWriter writer;
if ((!File.Exists(path)) || (!Append))
{
writer = new XmlTextWriter(path, System.Text.Encoding.UTF8);
}
else
{
Stream xmlFile = new System.IO.FileStream(path, FileMode.Append);
writer = new XmlTextWriter(xmlFile, System.Text.Encoding.UTF8);
}
return writer;
}
private static void CloseXMLWriter(XmlTextWriter writer)
{
writer.WriteEndDocument();
writer.Flush();
writer.Close();
}
}
/*
IMPORTANT NOTES:
Then to configure IIS, follow these steps:
Open IIS and navigate to the appropriate application/website
Right click and choose ‘Properties’ from the menu
Select the ‘HTTP Headers’ tab
There’s a section at the bottom entitled ‘MIME Map’, and from that click on ‘File Types’
Click ‘New Type’
For the ‘Associated extension’ enter .rss
And for ‘Content type (MIME)’ enter application/rss+xml
Click ‘OK’ and then ‘Apply’
Feel free to restart the IIS server, although you shouldn’t have to.
Ensure that the HTML page link to the RSS file includes the RSS extension, e.g.
*/
}
No comments:
Post a Comment