rss.aspx.cs

本程序基于 asp.net 2.0 +sql server 2

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Data.SqlClient;

public partial class rss : System.Web.UI.Page
{
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.ContentType="text/xml";
        if (Request.QueryString["userid"] != null)
            getUserBlog();
        else
            getNewBlog();
    }

    public void getUserBlog()
    {
        int userid = Convert.ToInt32(Request.QueryString["userid"].ToString());
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        string sql = "select top 10 nickname,left(puretext,300) puretext,add_date,blog.userid,blogid,title from blog,users where blog.userid=users.userid and text_folder=0";
        sql+=" and blog.userid="+userid +" order by blogid desc";
        SqlCommand cm = new SqlCommand(sql, cn);

        try
        {
            this.dr = cm.ExecuteReader();
            Response.Write(GetRSS());
        }
        finally
        {
            cn.Close();
        }
    
    }

    public void   getNewBlog()
    {
        int userid;

        if (Request.QueryString["userid"] != null)
            userid = Convert.ToInt32(Request .QueryString ["userid"]);

        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        string sql = "select top 25 nickname,left(puretext,300) puretext,add_date,blog.userid,blogid,title from blog,users where blog.userid=users.userid and text_folder=0 order by blogid desc";
        SqlCommand cm = new SqlCommand(sql, cn);

        try
        {
            this.dr = cm.ExecuteReader();
            Response .Write ( GetRSS ());
        }
        finally
        {
            cn.Close();
        }
    }

    public string GetRSS()
    {
        StringBuilder strCode = new StringBuilder();
        strCode.Append("<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\" ?>");
        strCode.Append("<rss version='2.0' xmlns:dc=\"http://purl.org/dc/elements/1.1/\"");
        strCode.Append(" xmlns:trackback=\"http://madskills.com/public/xml/rss/module/trackback/\" ");
        strCode.Append(" xmlns:wfw=\"http://wellformedweb.org/CommentAPI/\" xmlns:slash=\"http://purl.org/rss/1.0/modules/slash/\">");
        strCode.Append("<channel>");
        strCode.Append("<title>LaLaBlog RSS2</title>");
        strCode.Append("<link>http://" + Request.ServerVariables["SERVER_NAME"] + "</link> ");
        strCode.Append("<description>好生活，每一天</description> ");
        strCode.Append("<copyright>Copyright 2006</copyright> ");

        while (this.dr.Read ())
        {
            string userid = dr["userid"].ToString();
            string title = dr["title"].ToString();
            string puertext = dr["puretext"].ToString();
            string add_date = dr["add_date"].ToString();
            string nickname = dr["nickname"].ToString();
            int blogid = Convert.ToInt32(dr["blogid"].ToString());

            strCode.Append("<item>");
            strCode.Append("<title>" + title + "</title>");
            strCode.Append("<link>http://" + Request.ServerVariables["SERVER_NAME"] + "/article.aspx?userid=" + userid + "&amp;blogid=" + blogid + "</link>");
            strCode.Append("<subject>" + title  + "</subject>");
            strCode.Append("<description><![CDATA[" + puertext + "]]></description>");
            strCode.Append("<PubDate>" + add_date + "</PubDate>");
            strCode.Append("<Author>" + nickname + "</Author>");
            strCode.Append("</item>");
        }
        strCode.Append("</channel>");
        strCode.Append("</rss>");
        return strCode.ToString();
    }


}