private void Page_Load(object sender, System.EventArgs e) { //System.Text.StringBuilder sb = new System.Text.StringBuilder(256); System.Data.SqlClient.SqlDataReader dr; RSSFeed rssFeed = new RSSFeed("AdamKinney's Blog", "http://www.adamkinney.com/blog/", "GotDotNet Bard"); rssFeed.ImplementsSlash = true; rssFeed.Language = "en-us"; rssFeed.ManagingEditor = "*****@*****.**"; rssFeed.WebMaster = "*****@*****.**"; rssFeed.TTL = "60"; // dr = Set dr to SQLDataReader that selects posts from database. RSSItem item; while (dr.Read()) { item = new RSSItem(dr[1].ToString(), "<![CDATA[ " + dr[2].ToString() + " ]]>"); item.Author = "Adam Kinney"; item.Categories.Add(new RSSCategory(dr[3].ToString())); item.Comments = "http://www.adamkinney.com/blog/default.aspx?PostID=" + dr[0].ToString() + "#comments"; item.Slash.Comments = dr[5].ToString(); item.Guid = "http://www.adamkinney.com/blog/default.aspx?PostID=" + dr[0].ToString(); item.GuidIsPermalink = true; item.PubDate = DateTime.Parse(dr[4].ToString()).ToString("r"); item.SourceUrl = "http://www.adamkinney.com/blog/rss.aspx"; rssFeed.Items.Add(item); } Response.ContentType = "text/xml"; Response.Write(rssFeed.ToString()); }