ASP.NET MS SQL + DataReader + Generate RSS Feed

 
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();
   }