ASP.NET MS SQL + DataReader + Generate RSS Feed
rss.aspx.cs |
using System.Configuration; using System.Data.SqlClient; protected void Page_Load(object sender, EventArgs e) { Head("RSS", "http://127.0.0.1", "Testing RSS"); Get_Data(); Complete(); } private void Head(string Title, string Link, string Description) { Response.Write("<rss version=\"2.0\">"); Response.Write("<channel>"); Response.Write("<title>" + Title + "</title>"); Response.Write("<link>" + Link + "</link>"); Response.Write("<description>" + Description + "</description>"); } private void Complete() { Response.Write("</channel>"); Response.Write("</rss>"); } private void Content(string Title, string Link, string Description) { Response.Write("<item>"); Response.Write("<title>" + Title + "</title>"); Response.Write("<link>http://127.0.0.1/news/" + Link + ".aspx</link>"); Response.Write("<description>" + Description + "</description>"); Response.Write("</item>"); } private void Get_Data() { string connectionString1 = ConfigurationManager.ConnectionStrings["Conn_Str"].ConnectionString; SqlConnection con1 = new SqlConnection(connectionString1); con1.Open(); string SqlString1 = "SELECT * FROM News"; SqlCommand cmd1 = new SqlCommand(SqlString1, con1); SqlDataReader dr = cmd1.ExecuteReader(); if(dr.HasRows) { while(dr.Read()) { Content(dr["News_Name"].ToString().Trim(), dr["News_ID"].ToString().Trim(), dr["News_Content"].ToString().Trim()); } } dr.Close(); con1.Close(); con1.Dispose(); } |