using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;

public?partial?class?adminCourse?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!this.IsPostBack）
????????{
????????????ddlBind（）;
????????????CourceDetailsShow（）;
????????}
????}

????private?void?ddlBind（）
????{
????????string?connStr?=?ConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString;???//取出連接字符串
????????string?SqlStr?=?“SELECT?teaIDteaName?from?Teacher“;
????????DataSet?ds?=?new?DataSet（）;

????????SqlConnection?conn?=?new?SqlConnection（connStr）;????//創(chuàng)建連接對象
????????if?（conn.State.ToString（）?==?“Closed“）??????????????//如果連接關(guān)閉打開
????????????conn.Open（）;
????????SqlDataAdapter?da?=?new?SqlDataAdapter（SqlStr?conn）;
????????da.Fill（ds）;????????????????????????????????????????//從數(shù)據(jù)庫中取數(shù)據(jù)放到DataSet數(shù)據(jù)集中
????????if?（conn.State.ToString（）?==?“Open“）
????????????conn.Close（）;

????????ddlTeacherName.DataSource?=?ds.Tables[0].DefaultView;
????????ddlTeacherName.DataTextField?=?“teaName“;?????????????//下拉列表框每項顯示教師姓名
????????ddlTeacherName.DataValueField?=?“teaID“;??????????????//下拉列表框每項的值為教師編號
????????ddlTeacherName.DataBind（）;????????
????}
????private?void?CourceDetailsShow（）
????{
????????string?connStr?=?ConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString;???//取出連接字符串
????????string?SqlStr?=?“SELECT?Cource.*Teacher.teaName?from?CourceTeacher?where?Cource.teaID=Teacher.teaID?and?Cource.courceID=‘“?+?Request[“courceID“].ToString（）?+?“‘?and?Cource.teaID=‘“?+?Request[“teaID“].ToString（）?+?“‘“;
????????SqlConnection?conn?=?new?SqlConnection（connStr）;????//創(chuàng)建連接對象
????????try
????????{
????????????if?（conn.State.ToString（）?==?“Closed“）??????????//連接如果關(guān)閉，打開
????????????????conn.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?conn）;
????????????SqlDataReader?sdr?=?cmd.ExecuteReader（）;
????????????if?（sdr.Read（））
????????????{
????????????????courceName.Text?=?sdr[“courceName“].ToString（）;
????????????????txtName.Text?=?sdr[“courceName“].ToString（）;
????????????????ddlTeacherName.SelectedItem.Text?=?sdr[“teaName“].ToString（）;
????????????????txtTime.Text?=?sdr[“courceTime“].ToString（）;
????????????????txtAddress.Text?=?sdr[“courceAddress“].ToString（）;
????????????????txtDetails.Text?=?sdr[“courceInfo“].ToString（）;
????????????}
????????????else
????????????{
????????????????Response.Write（“數(shù)據(jù)庫錯誤，沒查詢到該門課程！“）;
????????????????Response.End（）;
????????????}
????????}
????????catch?（Exception?ex）????????????????????????????????//異常處理
????????{
????????????Response.Write（“數(shù)據(jù)庫錯誤，錯誤原因：“?+?ex.Message）;
????????????Response.End（）;
????????}
????????finally
????????{
????????????if?（conn.State.To