1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Data.SqlClient;
  6using System.Configuration;
  7using System.Drawing;
  8using System.Web;
  9using System.Web.SessionState;
 10using System.Web.UI;
 11using System.Web.UI.WebControls;
 12using System.Web.UI.HtmlControls;
 13
 14namespace STGROUP
 15...{
 16    /**//// <summary>
 17    /// ST_assigncourse 的摘要说明。
 18    /// </summary>
 19    public class ST_assigncourse : System.Web.UI.Page
 20    ...{
 21        protected System.Web.UI.WebControls.DropDownList st_ddl_teacher;
 22        protected System.Web.UI.WebControls.DropDownList st_ddl_course;
 23        protected System.Web.UI.WebControls.DropDownList st_ddl_class;
 24        protected System.Web.UI.WebControls.Button st_btn_ok;
 25        protected System.Web.UI.WebControls.TextBox st_tbx_year;
 26        protected System.Web.UI.WebControls.RequiredFieldValidator Rv_year;
 27        protected System.Web.UI.WebControls.RequiredFieldValidator Rv_teacher;
 28        protected System.Web.UI.WebControls.RequiredFieldValidator Rv_course;
 29        protected System.Web.UI.WebControls.Label st_lbl_note;
 30    
 31        private void Page_Load(object sender, System.EventArgs e)
 32        ...{//教师名称下拉列表框绑定
 33            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
 34            //连接本地计算机的st_StuManager数据库
 35            SqlConnection st_conn0= new SqlConnection (st_connstr);
 36            if(!IsPostBack)
 37            ...{
 38                st_conn0.Open ();
 39                string st_sql="select * from ST_teacher";
 40                SqlCommand st_comm0=new SqlCommand  (st_sql,st_conn0);
 41                SqlDataReader st_dr0=st_comm0.ExecuteReader ();
 42                while(st_dr0.Read ())
 43                ...{
 44                    st_ddl_teacher.Items .Add (new ListItem(st_dr0["ST_Teacher_name"].ToString(),st_dr0["ST_Teacher_id"].ToString()) );
 45                }
 46                st_conn0.Close ();
 47                //课程名称下拉列表框绑定
 48                st_conn0.Open ();
 49                string st_sql1="select * from ST_course";
 50                SqlCommand st_comm1=new SqlCommand  (st_sql1,st_conn0);
 51                SqlDataReader st_dr1=st_comm1.ExecuteReader ();
 52                while(st_dr1.Read ())
 53                ...{
 54                    st_ddl_course.Items .Add (new ListItem(st_dr1["ST_Course_name"].ToString() ,st_dr1["ST_Course_id"].ToString()) );
 55                }
 56                st_conn0.Close ();
 57                //班级名称下拉列表框绑定
 58                st_conn0.Open ();
 59                string st_sql2="select * from ST_class";
 60                SqlCommand st_comm2=new SqlCommand  (st_sql2,st_conn0);
 61                SqlDataReader st_dr2=st_comm2.ExecuteReader ();
 62                st_ddl_class.Items .Add (new ListItem("","") );
 63                while(st_dr2.Read ())
 64                ...{
 65                    st_ddl_class.Items .Add (new ListItem(st_dr2["ST_Class_name"].ToString() ,st_dr2["ST_Class_id"].ToString()) );
 66                }
 67                st_conn0.Close ();
 68            }
 69            // 在此处放置用户代码以初始化页面
 70
 71        }
 72
 73        Web Form Designer generated code#region Web Form Designer generated code
 74        override protected void OnInit(EventArgs e)
 75        ...{
 76            //
 77            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
 78            //
 79            InitializeComponent();
 80            base.OnInit(e);
 81        }
 82        
 83        /**//// <summary>
 84        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 85        /// 此方法的内容。
 86        /// </summary>
 87        private void InitializeComponent()
 88        ...{    
 89            this.st_btn_ok.Click += new System.EventHandler(this.st_btn_ok_Click);
 90            this.Load += new System.EventHandler(this.Page_Load);
 91
 92        }
 93        #endregion
 94
 95        private void st_btn_ok_Click(object sender, System.EventArgs e)
 96        ...{
 97            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
 98            SqlConnection st_conn= new SqlConnection (st_connstr);
 99            st_conn.Open();
100            string st_sqlstr="insert into ST_teacher_course(ST_Teacher_id,ST_Course_id,ST_Class_id,ST_Course_year) values(@Teacher_id,@Course_id,@Class_id,@Course_year)";
101            SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
102            st_comm.Parameters.Add(new SqlParameter("@Teacher_id",SqlDbType.VarChar,50));
103            st_comm.Parameters["@Teacher_id"].Value=st_ddl_teacher.SelectedItem.Value;
104            st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
105            st_comm.Parameters["@Course_id"].Value=st_ddl_course.SelectedItem.Value;
106            st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
107            st_comm.Parameters["@Class_id"].Value=st_ddl_class.SelectedItem.Value;
108            st_comm.Parameters.Add(new SqlParameter("@Course_year",SqlDbType.VarChar,50));
109            st_comm.Parameters["@Course_year"].Value=st_tbx_year.Text;            
110            try
111            ...{
112                st_comm.ExecuteNonQuery();
113                st_lbl_note.Text="添加成功，请返回";
114                
115            }
116            catch(SqlException)
117            ...{
118                st_lbl_note.Text="添加失败";
119                st_lbl_note.Style["color"]="red";
120            }    
121            st_conn.Close();
122        }
123    }
124}
125