|
protected void CreateRss()
{
//定义数据库链接字符串
string connStr =
"server=服务器名称;database=数据库名称;uid=数据库帐号;pwd=密码";
//定义SQL语句
string strSql =
"select top 50 * from news where typename = '新闻动态'";
//创建数据库连接对象
SqlConnection conn = new
SqlConnection();
//定义数据适配器,用来转载数据集
SqlDataAdapter da = new
SqlDataAdapter();
//创建数据集
DataSet ds = new DataSet();
//装载数据集
da.Fill(ds);
//生成xml文件
Response.Clear();
Response.ContentType = "text/xml";
XmlTextWriter objX = new
XmlTextWriter(Response.OutputStream, Encoding.UTF8);
objX.WriteStartDocument();
objX.WriteStartElement("rss");
objX.WriteAttributeString("version","2.0");
objX.WriteStartElement("channel");
objX.WriteElementString("title",portalSettings.PortalName+"");
objX.WriteElementString("link",ConfigurationSettings.AppSettings["BaseUrl"]);
objX.WriteElementString("description",portalSettings.PortalName+"Rss 新闻");
objX.WriteElementString("copyright","(c) 2005, All rights reserved.");
objX.WriteElementString("ttl","5");
InfosDB infosDB = new
InfosDB();
DataView dv = ds.Tables["0"].DefaultView;
// 将从数据库读出的每一条新闻信息,输出到xml文件中的item项。
foreach (DataRowView
myDRV in dv)
{
objX.WriteStartElement("item");
objX.WriteElementString("title",myDRV["Title"].ToString());
objX.WriteElementString("description",Filter(myDRV["Content"].ToString()));
objX.WriteElementString("link",myDRV["Link"].ToString()));
objX.WriteElementString("pictureUrl",myDRV["PictureUrl"].ToString());
if(myDRV["PictureUrl"]!=null
&& myDRV["PictureUrl"].ToString()!="")
{
objX.WriteElementString("pubDate",((DateTime)myDRV["publishDate"]).ToString());
}
objX.WriteEndElement();
}
infosDB.Dispose();
objX.WriteEndElement();
objX.WriteEndElement();
objX.WriteEndDocument();
objX.Flush();
objX.Close();
Response.End();
}
|