rss订阅程序实现

生成xml页面

using System;
using System.Data;
using System.Configuration;
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.IO;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
         string Tablename = "Tb_Test";
        string fname = System.Web.HttpContext.Current.Server.MapPath("RSS_Folder") + "\\" + Tablename + ".XML";
        GetRss.WriteRss(fname, Tablename);

    }
}

生成xml类页面

using System;
using System.Data;
using System.Configuration;
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.IO;

public class GetRss
{
    /** <summary>
    /// 根据文件路径写RSS文件
    /// </summary>
    /// <remarks>
    /// 例如: 
    ///  WriteRss("D:Vs2005GenerateRssRSS_Folder est_tb.xml","test_tb")
    /// 注意：根据表的结构,需要调整生成的RSS源。本实例仅供测试用。
    /// </remarks>
    /// <param name="pathfilename">文件路径</param>
    /// <param name="tablename">表名</param>
    /// <returns>true or false</returns>
    public static bool WriteRss(string pathfilename,string tablename)
    {
        try
       {
            FileInfo finfo = new FileInfo(pathfilename);
            using (FileStream fs = finfo.OpenWrite())
            {
                StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("UTF-8"));
                sw.WriteLine(GetRss.GetRSSString(tablename));
                sw.Flush();
                sw.Close();
            }
            return true;
        }
        catch (System.Exception ex)
       {
            System.Web.HttpContext.Current.Response.Write(ex.Message);
            return false;
            throw;
        }
    
    }

    /** <summary>
    /// 组织符合最新标准的RSS字符串
    /// 参数：表名。
    /// </summary>
    /// <remarks>
    /// 例如: 
    ///  GetRSS()
    /// 注意：根据表的结构,需要调整生成的RSS源。本实例仅供测试用。
    /// </remarks>
    /// <param name="tablename">表名</param>
    /// <returns>返回一个DataSet 数据源</returns>
    public static string GetRSSString(string Tablename)
    {
        try
        {
            DataSet ds = GetRSSData(Tablename);
            string strRSS = "";
            strRSS = strRSS + "<?xml version=\"1.0\" encoding=\"utf-8\"?>" + System.Environment.NewLine;
            strRSS = strRSS + " <rss version=\"2.0\" xmlns:dc=\"http://purl.org/dc/elements/1.1//" xmlns:trackback=\"http://madskills.com/public/xml/rss/module/trackback//" xmlns:wfw=\"http://wellformedweb.org/CommentAPI//" xmlns:slash=\"http://purl.org/rss/1.0/modules/slash//">" + System.Environment.NewLine;
            strRSS = strRSS + "  <channel xmlns:cfi=\"http://www.microsoft.com/schemas/rss/core/2005/internal/" cfi:lastdownloaderror=\"None\">" + System.Environment.NewLine;
            strRSS = strRSS + "  <title>订阅标题</title> " + System.Environment.NewLine;
            strRSS = strRSS + "  <link>http://www.**com.cn/</link>" + System.Environment.NewLine;
            strRSS = strRSS + "  <description>描述信息</description>" + System.Environment.NewLine;
            strRSS = strRSS + "  <language>zh-CN</language>" + System.Environment.NewLine;
            strRSS = strRSS + "  <generator>www.**com.cn</generator>  " + System.Environment.NewLine;
            strRSS = strRSS + "  <copyright>北京**公司</copyright> " + System.Environment.NewLine;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                strRSS = strRSS + " <item>" + System.Environment.NewLine;
                strRSS = strRSS + " <title>" + ds.Tables[0].Rows[i]["bt"] + "</title> " + System.Environment.NewLine;
                strRSS = strRSS + " <link>http://www.**.com.cn/ArticleShow@" + ds.Tables[0].Rows[i]["ID"] + ".html</link> " + System.Environment.NewLine;
                strRSS = strRSS + " <author /> " + System.Environment.NewLine;
                strRSS = strRSS + " <guid>http://www.**.com.cn/ArticleShow@" + ds.Tables[0].Rows[i]["ID"] + ".html</guid>   " + System.Environment.NewLine;
                strRSS = strRSS + " <pubDate>" + Convert.ToDateTime(ds.Tables[0].Rows[i]["sj"].ToString()).ToString("yyyy-MM-dd HH:mm") + "</pubDate> " + System.Environment.NewLine;
                strRSS = strRSS + " <comments>http://www.**.com.cn/ArticleShow@" + ds.Tables[0].Rows[i]["ID"] + ".html</comments>   " + System.Environment.NewLine;
                strRSS = strRSS + " <slash:comments>0</slash:comments>    " + System.Environment.NewLine;
                strRSS = strRSS + " <source url='http://www.**.com.cn/ArticleShow@" + ds.Tables[0].Rows[i]["ID"] + ".html'>" + ds.Tables[0].Rows[i]["bt"] + " </source>  " + System.Environment.NewLine;
                strRSS = strRSS + " <description>" + ds.Tables[0].Rows[i]["nr"] + "</description>" + System.Environment.NewLine;
                strRSS = strRSS + " </item>" + System.Environment.NewLine;
            }
            strRSS = strRSS + " </channel>" + System.Environment.NewLine;
            strRSS = strRSS + " </rss>" + System.Environment.NewLine;
            return strRSS;
        }
        catch (Exception ex)
       {
            System.Web.HttpContext.Current.Response.Write(ex.Message);
            throw;
        }
    }

    /** <summary>
    /// 获取RSS数据源
    /// 参数：表名。
    /// </summary>
    /// <remarks>
    /// 例如: 
    ///  DataSet ds = GetRSSData(TableName)
    /// 注意：根据表的结构,需要调整生成的RSS源。本实例仅供测试用。
    /// </remarks>
    /// <param name="Tablename">表名</param>
    /// <returns>返回一个DataSet 数据源</returns>
    public static DataSet GetRSSData(string Tablename)
    {
        String DBConnStr = System.Configuration.ConfigurationManager.AppSettings["conn"];
        System.Data.SqlClient.SqlDataAdapter DataAdapter = new System.Data.SqlClient.SqlDataAdapter();
        System.Data.SqlClient.SqlConnection Connection = new System.Data.SqlClient.SqlConnection(DBConnStr);
        if (Connection.State != ConnectionState.Open)
      {
            Connection.Open();
        }

        try
        {
            System.Data.SqlClient.SqlCommand Command = new System.Data.SqlClient.SqlCommand("SELECT * from bb ", Connection);
            Command.CommandType = CommandType.Text;
            //Command.Parameters.Add("@TABLENAME", SqlDbType.VarChar, 20);
            //Command.Parameters["@TABLENAME"].Value = Tablename;
            //Command.Parameters.Add("@COLUMNS", SqlDbType.VarChar, 2000);
            //Command.Parameters["@COLUMNS"].Value = "";
            Command.ExecuteNonQuery();
            DataAdapter.SelectCommand = Command;
            DataSet DataSet = new DataSet();
            if (DataSet != null)
           {
                DataAdapter.Fill(DataSet, "table");
            }
            return DataSet;
           
        }
        catch (System.Exception ex)
        {
            System.Web.HttpContext.Current.Response.Write(ex.Message);
            Connection.Close();
            throw;

        }
    }

}

 

读取xml页面

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;

public partial class index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        ReadRss rss = new ReadRss();
        Label1.Text = rss.ProcessRSSItem(TextBox1.Text);
    }
}
读取xml类

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// ReadRss 的摘要说明
/// </summary>
public class ReadRss
{
 public ReadRss()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    public string ProcessRSSItem(string rssURL)
    {
        string str = "";
        System.Net.WebRequest myRequest = System.Net.WebRequest.Create(rssURL);
        System.Net.WebResponse myResponse = myRequest.GetResponse();

        System.IO.Stream rssStream = myResponse.GetResponseStream();
        System.Xml.XmlDocument rssDoc = new System.Xml.XmlDocument();
        rssDoc.Load(rssStream);

        System.Xml.XmlNodeList rssItems = rssDoc.SelectNodes("/rss/channel/item");

        string title = "";
        string link = "";
        string description = "";

        for (int i = 0; i < rssItems.Count; i++)
        {
            System.Xml.XmlNode rssDetail;

            rssDetail = rssItems.Item(i).SelectSingleNode("title");
            if (rssDetail != null)
            {
                title = rssDetail.InnerText;
            }
            else
            {
                title = "";
            }

            rssDetail = rssItems.Item(i).SelectSingleNode("link");
            if (rssDetail != null)
            {
                link = rssDetail.InnerText;
            }
            else
            {
                link = "";
            }
            rssDetail = rssItems.Item(i).SelectSingleNode("link");

            if (rssDetail != null)
            {

                link = rssDetail.InnerText;

            }

            else
            {

                link = "";

            }

            rssDetail = rssItems.Item(i).SelectSingleNode("description");

            if (rssDetail != null)
            {

                description = rssDetail.InnerText;

            }
            else
            {

                description = "";

            }
            if (title.Length > 200)
            {
                title = title.Substring(0, 200);
            }

            str += "<li><a href='"+link+"' title='"+title+"' target='_blank'>"+title+"</a></li>";
        }
        return str;
    }

    public string ReadNews(string rssURL)
    {
        string str = "";
        System.Net.WebRequest myRequest = System.Net.WebRequest.Create(rssURL);
        System.Net.WebResponse myResponse = myRequest.GetResponse();

        System.IO.Stream rssStream = myResponse.GetResponseStream();
        System.Xml.XmlDocument rssDoc = new System.Xml.XmlDocument();
        rssDoc.Load(rssStream);

        System.Xml.XmlNodeList rssItems = rssDoc.SelectNodes("/rss/channel/item");

        string title = "";
        string link = "";
        string description = "";
        string source = "";

        for (int i = 0; i < rssItems.Count; i++)
        {
            System.Xml.XmlNode rssDetail;

            rssDetail = rssItems.Item(i).SelectSingleNode("title");
            if (rssDetail != null)
            {
                title = rssDetail.InnerText;
            }
            else
            {
                title = "";
            }

            rssDetail = rssItems.Item(i).SelectSingleNode("link");
            if (rssDetail != null)
            {
                link = rssDetail.InnerText;
            }
            else
            {
                link = "";
            }
            rssDetail = rssItems.Item(i).SelectSingleNode("link");

            if (rssDetail != null)
            {

                link = rssDetail.InnerText;

            }

            else
            {

                link = "";

            }

            rssDetail = rssItems.Item(i).SelectSingleNode("description");

            if (rssDetail != null)
            {

                description = rssDetail.InnerText;

            }

            else
            {

                description = "";

            }

            rssDetail = rssItems.Item(i).SelectSingleNode("source");
            if(rssDetail!=null)
            {
                source = rssDetail.InnerText;
            }
            else
            {
                source = "";
            }
            if (title.Length > 200)
            {
                title = title.Substring(0,200);
            }

            str += "★<a href='" + link + "' title='" + title + "' target='_blank'>" + title + "</a>&nbsp;&nbsp;&nbsp;&nbsp;来源：" + source + "<br/>";
        }
        return str;
    }
}

转载于:https://www.cnblogs.com/dam889/archive/2009/07/22/1528423.html