using System.Text;
using System.Xml;
using System.Data.SqlClient;
protected void Page_Load(object sender, EventArgs e)
{
Response.Clear();
Response.ContentType = "text/xml";
XmlTextWriter xtw = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
xtw.WriteStartDocument();
string processtext = "type=\"text/xsl\" href=\"rss.xsl\"";
xtw.WriteProcessingInstruction("xml-stylesheet", processtext);
xtw.WriteStartElement("rss");
xtw.WriteAttributeString("version", "2.0");
xtw.WriteStartElement("channel");
xtw.WriteElementString("title", "Latest Articles List");
xtw.WriteElementString("link", "http://www.yourwebsite.com/");
xtw.WriteElementString("description", "some description here");
string sql = "Select * from Articles Order by Created_Date Desc";
SqlDataAdapter da = new SqlDataAdapter(sql, "Your connection string");
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
xtw.WriteStartElement("item");
xtw.WriteElementString("title", dt.Rows[i]["Art_Title"].ToString());
xtw.WriteElementString("description", dt.Rows[i]["Art_Subject"].ToString());
xtw.WriteElementString("link", "http://www.yourwebsite.com/"+dt.Rows[i]["Art_Url"].ToString());
xtw.WriteElementString("pubDate",XmlConvert.ToString(Convert.ToDateTime(dt.Rows[i]["L_Update"].ToString())));
xtw.WriteEndElement();
}
}
xtw.WriteEndElement();
xtw.WriteEndElement();
xtw.WriteEndDocument();
xtw.Flush();
xtw.Close();
}