rss.aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="rss.aspx.cs" Inherits="Solorez.RSS" Debug="true" %>
rss.aspx.cs:
using System;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace Solorez
{
partial class RSS : System.Web.UI.Page
{
string strRSS = "";
private void Page_Load(object sender, System.EventArgs e)
{
Response.ContentType = "application/xml"; // 输出并按xml数据显示
Response.Write(GetRSS());
}
public string GetRSS()
{
DataTable dt = GetNews(); // 调用GetNews()方法,获得数据
string br = Environment.NewLine;
strRSS = strRSS + "<rss version=\"2.0\">" + br;
strRSS = strRSS + "<channel>" + br;
strRSS = strRSS + "<title>Solorez新闻</title>" + br;
strRSS = strRSS + "<link>http://hi.baidu.com/solorez</link>" + br;
strRSS = strRSS + "<description>欢迎订阅Solorez</description>" + br;
for (int i = 0; i < dt.Rows.Count; i++);{
strRSS = strRSS + "<item>" + br;
strRSS = strRSS + "<title><![CDATA[" + dt.Rows[i]["Heading"] + "]]></title>" + br;
strRSS = strRSS + "<link>" + "http://hi.baidu.com/solorez/news.aspx?id=" + dt.Rows[i]["id"] + "</link> " + br;
strRSS = strRSS + "<description><![CDATA[" + dt.Rows[i]["NewsContent"] + "]]></description>" + br;
strRSS = strRSS + "<copyright>Solorez</copyright>" + br;
strRSS = strRSS + "<pubDate>" + dt.Rows[i]["InsertTime"] + "</pubDate>" + br;
strRSS = strRSS + "</item>" + br;
strRSS = strRSS + "</channel>" + br;
strRSS = strRSS + "</rss>";
}
return strRSS;
}
public DataTable GetNews()
{
SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
DataTable newsTable = new DataTable();
string queryString = "SELECT TOP 10 ID,InsertTime,Heading,NewsContent FROM News ORDER BY InsertTime DESC";
SqlDataAdapter adapter = new SqlDataAdapter(queryString,connection);
adapter.Fill(newsTable);
return newsTable;
}
}
}
小光网络技术博客
介绍和研究搜索引擎优化、SEO、asp、asp.net、php、jsp技术
- 相关文章:
ASP.NET2.0 上传图片并为用户创建相应文件夹 (2008-5-10 11:12:34)
asp.net输出纯xml格式数据 (2008-5-7 11:19:45)
TreeView的用法 (2008-4-5 14:17:46)
Ajax无刷新实现图片切换特效 (2008-4-2 16:21:11)
ajaxpro在vs2005中应用 (2008-4-1 15:15:58)
asp.net导出excel (2008-3-21 10:54:38)
ASP.NET无限级分类的非递归实现(存储过程版） (2008-3-15 14:13:19)
asp.net反编译方法 (2008-3-13 11:53:10)
在ASP.NET中实现AJAX 3 (2008-3-9 23:24:25)
在ASP.NET中实现AJAX 2 (2008-3-9 23:23:17)
◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。