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!

If this kind of stuff has value, please support me by tossing a one time PayPal kibble or monthly on Patreon
Become a patron at Patreon!
Profile Picture for CogDog The Blog
An early 90s builder of web stuff 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. And he is 100% into the Fediverse (or tells himself so) Tooting as @cogdog@cosocial.ca