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!

The post "This is the “Simple” Way to Build RSS? Yikes!" was originally emerged from the primordial ooze and first walked on land at CogDogBlog (http://cogdogblog.com/2004/01/this-is/) on January 30, 2004.

Comments are closed.