cogdogblog

Note: CogDogBlog has a new WordPress powered home at http://cogdogblog.com/. All entries from this version have been moved there, so as a guide dog service try finding this article in its new home by title search.

This is the "Simple" Way to Build RSS? Yikes!

Building an RSS feed made simple came the link in my blog. Hmmm, we can alway use more simplicity...

Wow, this is simple:

SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings["MyConnectionString"]);
objConnection.Open();
string sql = "SELECT TOP 10 Title, Summary, ArticleID, PostTime FROM Articles ORDER BY PostTime DESC";
SqlCommand objCommand = new SqlCommand(sql, objConnection);
SqlDataReader objReader = objCommand.ExecuteReader();
while (objReader.Read())
{
objX.WriteStartElement("item");

I would hate to see the hard way ;-) I realize this is an ASP coders page, but perhaps we need some international standards on defining simple!