1using System;
 2using System.Collections;
 3using System.ComponentModel;
 4using System.Data;
 5using System.Data.SqlClient;
 6using System.Drawing;
 7using System.Web;
 8using System.Web.SessionState;
 9using System.Web.UI;
10using System.Web.UI.WebControls;
11using System.Web.UI.HtmlControls;
12using System.Configuration;
13
14namespace STGROUP
15...{
16    /**//// <summary>
17    /// ST_course_teacher 的摘要说明。
18    /// </summary>
19    public class ST_course_teacher : System.Web.UI.Page
20    ...{
21        protected System.Web.UI.WebControls.Repeater st_rp_course;
22    
23        private void Page_Load(object sender, System.EventArgs e)
24        ...{
25            // 在此处放置用户代码以初始化页面
26            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
27            SqlConnection st_conn=new SqlConnection(st_connstr);
28            string  st_sqlstr="select ST_Course_name,ST_Teacher_name,ST_Teacher_college,ST_Course_describe,ST_Class_name from ST_course,ST_teacher,ST_teacher_course,ST_class where ST_course.ST_Course_id=@id and ST_teacher.ST_Teacher_id=ST_teacher_course.ST_Teacher_id and ST_teacher_course.ST_Course_id=ST_course.ST_Course_id and ST_teacher_course.ST_Class_id=ST_class.ST_Class_id";
29            SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
30            st_comm.Parameters.Add(new SqlParameter("@id",SqlDbType.VarChar,50));
31            st_comm.Parameters["@id"].Value=Request.QueryString["ST_Course_id"];
32            st_conn.Open();
33            SqlDataReader st_dr=st_comm.ExecuteReader();
34            st_rp_course.DataSource=st_dr;
35            st_rp_course.DataBind();
36            st_conn.Close();
37        }
38
39        Web Form Designer generated code#region Web Form Designer generated code
40        override protected void OnInit(EventArgs e)
41        ...{
42            //
43            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
44            //
45            InitializeComponent();
46            base.OnInit(e);
47        }
48        
49        /**//// <summary>
50        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
51        /// 此方法的内容。
52        /// </summary>
53        private void InitializeComponent()
54        ...{    
55            this.Load += new System.EventHandler(this.Page_Load);
56
57        }
58        #endregion
59
60        private void st_btn_exit_Click(object sender, System.EventArgs e)
61        ...{
62            Response.Redirect("ST_course.aspx");
63        }
64
65    }
66}
67