前台文件： /><%@ Page language="c#" Codebehind="podcast.aspx.cs" ContentType="text/xml" AutoEventWireup="false" Inherits="WebApplicationwotiankeji.asp.procast" %><?xml version="1.0" encoding="GB2312"?><rss version="2.0"><asp:Repeater id="reapter_blog_programe" runat="server"><HeaderTemplate> <channel> <title> <%Response.Write(str_blog_name);%> </title> <link> http://www.lifepop.com/myradio.aspx?domain=<%Response.Write(str_blog_links);%></link> <description> <%Response.Write(str_blog_description);%> </description> <copyright>http://www.lifepop.com</copyright> <generator>www.lifepop.com Podcast System</generator> <webMaster>lifepop@hotmail.com</webMaster></HeaderTemplate><ItemTemplate><asp:Label Runat=server ID=programeid Text='<%# DataBinder.Eval(Container.DataItem,"program_id")%>' visible=false></asp:Label> <item> <title><![CDATA[<%# FormatForXML(DataBinder.Eval(Container.DataItem,"p_title"))%>]]></title> <link>http://www.lifepop.com/myradio.aspx?castid=<%# DataBinder.Eval(Container.DataItem,"program_id")%></link> <author><%Response.Write(str_blog_user);%></author> <pubDate><%# DataBinder.Eval(Container.DataItem,"p_public_time")%></pubDate> <description><![CDATA[<%# FormatForXML(DataBinder.Eval(Container.DataItem,"p_content"))%>]]></description> <asp:Repeater id="repeater_programe_url" runat="server"> <ItemTemplate> <enclosure url="<%# DataBinder.Eval(Container.DataItem,"my_url")%>" length="" type="audio/mpeg" /> </ItemTemplate> </asp:Repeater> </item> </ItemTemplate><FooterTemplate> </channel></FooterTemplate></asp:Repeater></rss>
后台文件：using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;
namespace WebApplicationwotiankeji.asp{ /// <summary> /// procast 的摘要说明。 /// </summary> public class procast : System.Web.UI.Page { protected System.Web.UI.WebControls.Repeater reapter_blog_programe; protected System.Web.UI.WebControls.Repeater repeater_programe_url; public string str_blog_user=string.Empty; //播客电台的主人 public string str_blog_name=string.Empty; //播客名称 public string str_domain_name=string.Empty; public string str_blog_links=string.Empty; //播客连接 public string str_blog_description=string.Empty; //播客描述 private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 str_domain_name=Request.Params["domain"]; str_domain_name="test"; // 在此处放置用户代码以初始化页面 select_blog_info(str_domain_name); select_programe_by_domain_name(str_domain_name); } private void select_blog_info(string str_parameter) { SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"]); string str_sql="select r_name,r_name,r_username,r_about,r_domain_name from user_radio_info where r_domain_name=@domain_name"; SqlCommand mysqlcommand = new SqlCommand(str_sql,myConnection); mysqlcommand.CommandType = CommandType.Text; mysqlcommand.CommandText=str_sql; mysqlcommand.Parameters.Add("@domain_name",SqlDbType.NVarChar,100); mysqlcommand.Parameters["@domain_name"].value="/str_domain_name; myConnection.Open(); SqlDataReader" mydatareader=mysqlcommand.ExecuteReader(); while(mydatareader.Read()) { str_blog_name=Convert.ToString(mydatareader["r_name"]); str_blog_links=Convert.ToString(mydatareader["r_domain_name"]); str_blog_description=Convert.ToString(mydatareader["r_about"]); str_blog_user=Convert.ToString(mydatareader["r_username"]); } mydatareader.Close(); myConnection.Close(); } //查询节目 private void select_programe_by_domain_name(string str_domain_name) { SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"]); string str_sql="select top 10 program_info.p_public_time,program_info.p_content,program_info.p_title,program_info.program_id from program_info where program_info.u_domain_name=@domain_name and(program_info.p_big_class=2 or program_info.p_big_class=3 or program_info.p_big_class=4) order by program_info.program_id desc"; SqlCommand mysqlcommand = new SqlCommand(str_sql,myConnection); mysqlcommand.CommandType = CommandType.Text; mysqlcommand.CommandText=str_sql; mysqlcommand.Parameters.Add("@domain_name",SqlDbType.NVarChar,100); mysqlcommand.Parameters["@domain_name"].value="/str_domain_name; myConnection.Open(); SqlDataReader" mydatareader=mysqlcommand.ExecuteReader(); reapter_blog_programe.DataSource=mydatareader; reapter_blog_programe.DataBind(); myConnection.Close(); } public 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; } //模板绑定 private void reapter_blog_programe_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Label lblTypeID = lblTypeID =(Label)e.Item.FindControl("programeid"); ; Repeater rptProduct = (Repeater) e.Item.FindControl("repeater_programe_url"); SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"]); string str_sql="select my_url from myprograme_info where my_pr_id=@int_pid"; SqlCommand mysqlcommand = new SqlCommand(str_sql,myConnection); mysqlcommand.CommandType = CommandType.Text; mysqlcommand.CommandText=str_sql; mysqlcommand.Parameters.Add("@int_pid",SqlDbType.Int); mysqlcommand.Parameters["@int_pid"].value="/Convert.ToInt32(lblTypeID.Text.Trim()); myConnection.Open(); //Response.Write(str_sql); //Response.End(); " SqlDataReader mydatareader1=mysqlcommand.ExecuteReader(); rptProduct.DataSource =mydatareader1; rptProduct.DataBind(); myConnection.Close(); }
} #region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() {
this.reapter_blog_programe.ItemDataBound += new System.Web.UI.WebControls.RepeaterItemEventHandler(this.reapter_blog_programe_ItemDataBound); this.Load += new System.EventHandler(this.Page_Load);
} #endregion
}}
