Blog Pile

This is the “Simple” Way to Build RSS? Yikes!


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!

Profile Picture for Alan Levine aka CogDog
An early 90s builder of the web and blogging Alan Levine barks at CogDogBlog.com on web storytelling (#ds106 #4life), photography, bending WordPress, and serendipity in the infinite internet river. He thinks it's weird to write about himself in the third person.