產生rss的基本c#代碼

//從收錄資料庫中取出內容產生不同的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();
        }