三:ASP.NET输出RSS
输出rss文档的比较简单,如下例子:
<%@ Page language="c#" ContentType="text/xml;charset=gb2312" %>
<script language="c#" runat="server">
void Page_Load(object sender,EventArgs e)
{
Cmder.Data.MsSql conn = new Cmder.Data.MsSql();
conn.ConnectionString=AppDataStr();
string sql="select top 5 info_id,user_id,info_title,info_time from l_info order by info_id desc";
rptRSS.DataSource =conn.MDataSet(sql);
rptRSS.DataBind();
}
public string AppDataStr(){
return System.Configuration.ConfigurationSettings.AppSettings["connectString"].ToString();
}
string FormatForXML(object input)
{
string data = input.ToString(); // cast the input to a string
// replace those characters disallowed in XML documents
data = data.Replace("&", "&");
data = data.Replace("\"", """);
data = data.Replace("'", "'");
data = data.Replace("<", "<");
data = data.Replace(">", ">");
return data;
}
</script>
<asp:Repeater id="rptRSS" runat="server">
<HeaderTemplate>
<?xml version="1.0" encoding="gb2312"?>
<?xml-stylesheet href="rss.xsl" type="text/xsl" media="all"?>
<rss version="2.0" xmlnsc="http://purl.org/dc/elements/1.1/" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:admin="http://webns.net/mvcb/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
<channel>
<title>老农专注数据库编程</title>
<link>http://www.5do8.com/</link>
<description>老农如是想如是为</description>
<copyright>copyright by 5do8</copyright>
</HeaderTemplate>
<ItemTemplate>
<item>
<title><%# FormatForXML(DataBinder.Eval(Container.DataItem,
"info_title")) %></title>
<description>
<%# FormatForXML(DataBinder.Eval(Container.DataItem,
"info_title")) %>
</description>
<link>
http://www.5do8.com/blog/news.asp?id=<%#
DataBinder.Eval(Container.DataItem, "info_id") %>
</link>
<author><%# FormatForXML(DataBinder.Eval(Container.DataItem,
"user_id")) %></author>
<pubDate>
<%# String.Format("{0:R}",
DataBinder.Eval(Container.DataItem,
"info_time")) %>
</pubDate>
</item>
</ItemTemplate>
<FooterTemplate>
</channel>
</rss>
</FooterTemplate>
</asp:Repeater>
如果您的数据量比较大的话,建议参与文件缓存或者cache等处理,不要每次都读取数据库.
最后,使用了xsl样式表样式格式化了rss.
