生成rss的基本c#代码

<script type="text/javascript"> </script><script type="text/javascript"> </script><script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> // 从收录数据库中取出内容生成不同的rss，mycon中的数据表中至少应包括title、description、link、pubDate、author字段
         public   void  DB2rss(OleDbConnection mycon, string  XmlFile)
         {
            XmlTextWriter objX  = new XmlTextWriter(Server.MapPath(XmlFile), System.Text.Encoding.GetEncoding("GB2312"));

            objX.Formatting = Formatting.Indented;

            objX.WriteStartDocument();

            objX.WriteStartElement("rss");
            objX.WriteAttributeString("version", "2.0");
            objX.WriteStartElement("channel");
            objX.WriteElementString("title", "肉香鱼丝的rss");
            objX.WriteElementString("description", "肉香鱼丝收集整理的有用的东东。");
            objX.WriteElementString("copyright", "Copyright (C) 2007 肉香鱼丝");
            objX.WriteElementString("ttl", "5");//rss更新时间
            objX.WriteElementString("pubDate", DateTime.Now.ToString());
            string strCom = "*****";//*****代表具体的SQL语句，select出title、description、link、pubDate、author
            OleDbCommand myCommand = new OleDbCommand( strCom , mycon ) ;
            OleDbDataReader dr=myCommand.ExecuteReader();
            while(dr.Read())
            {
                objX.WriteStartElement("item");
                objX.WriteElementString("title", dr.GetString(0));
                objX.WriteElementString("description", dr.GetString(1));
                objX.WriteElementString("link", dr.GetString(2));
                objX.WriteElementString("pubDate",dr.GetDateTime(3).ToString());
                objX.WriteElementString("author", dr.GetString(4));
                objX.WriteEndElement();
            }
            dr.Close();
            objX.WriteEndElement();
            objX.WriteEndElement();
            objX.WriteEndDocument();
            objX.Flush();
            objX.Close();
        }