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）;????//創建連接對象
????????if?（conn.State.ToString（）?==?“Closed“）??????????????//如果連接關閉打開
????????????conn.Open（）;
????????SqlDataAdapter?da?=?new?SqlDataAdapter（SqlStr?conn）;
????????da.Fill（ds）;????????????????????????????????????????//從數據庫中取數據放到DataSet數據集中
????????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）;????//創建連接對象
????????try
????????{
????????????if?（conn.State.ToString（）?==?“Closed“）??????????//連接如果關閉，打開
????????????????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（“數據庫錯誤，沒查詢到該門課程！“）;
????????????????Response.End（）;
????????????}
????????}
????????catch?（Exception?ex）????????????????????????????????//異常處理
????????{
????????????Response.Write（“數據庫錯誤，錯誤原因：“?+?ex.Message）;
????????????Response.End（）;
????????}
????????finally
????????{
????????????if?（conn.State.To

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????2330??2007-03-05?17:25??MyElectCourse\adminCourse.aspx

?????文件???????4908??2007-03-05?17:25??MyElectCourse\adminCourse.aspx.cs

?????文件???????9713??2007-03-05?17:25??MyElectCourse\adminCourseDetails.aspx

?????文件???????8518??2007-03-05?17:25??MyElectCourse\adminCourseDetails.aspx.cs

?????文件???????3516??2007-03-05?17:25??MyElectCourse\adminStudentAdd.aspx

?????文件???????2607??2007-03-05?17:25??MyElectCourse\adminStudentAdd.aspx.cs

?????文件???????4824??2007-03-05?17:25??MyElectCourse\adminStudentDetails.aspx

?????文件???????7906??2008-04-14?15:06??MyElectCourse\adminStudentDetails.aspx.cs

?????文件???????3574??2007-03-05?17:25??MyElectCourse\adminStudentScore.aspx

?????文件???????8329??2007-03-05?17:25??MyElectCourse\adminStudentScore.aspx.cs

?????文件???????2227??2007-03-05?17:25??MyElectCourse\adminTeacherAdd.aspx

?????文件???????2420??2007-03-05?17:25??MyElectCourse\adminTeacherAdd.aspx.cs

?????文件???????3328??2007-03-05?17:25??MyElectCourse\adminTeacherDetails.aspx

?????文件???????5711??2007-03-05?17:25??MyElectCourse\adminTeacherDetails.aspx.cs

?????文件???10485760??2007-03-05?17:25??MyElectCourse\App_Data\ASPNETDB.MDF

?????文件?????516096??2007-03-05?17:25??MyElectCourse\App_Data\aspnetdb_log.ldf

?????文件???????2224??2007-03-05?17:25??MyElectCourse\Controls\left.ascx

?????文件????????534??2007-03-05?17:25??MyElectCourse\Controls\left.ascx.cs

?????文件???????1977??2007-03-05?17:25??MyElectCourse\courseDetail.aspx

?????文件???????2461??2007-03-05?17:25??MyElectCourse\courseDetail.aspx.cs

?????文件????3145728??2008-04-14?15:13??MyElectCourse\DB_51aspx\ElectClass.mdf

?????文件????1048576??2008-04-14?15:13??MyElectCourse\DB_51aspx\ElectClass_log.ldf

?????文件???????4945??2007-07-18?09:38??MyElectCourse\from.gif

?????文件???????1265??2007-03-05?17:25??MyElectCourse\Images\ADD.GIF

?????文件???????4945??2007-07-18?09:38??MyElectCourse\Images\Can.gif

?????文件???????1056??2007-03-05?17:25??MyElectCourse\Images\Close.GIF

?????文件????????505??2007-03-05?17:25??MyElectCourse\Images\CONFIRM.GIF

?????文件???????1584??2007-03-05?17:25??MyElectCourse\Images\FangKuai.gif

?????文件???????4945??2007-07-18?09:38??MyElectCourse\Images\from.gif

?????文件???????1073??2007-03-05?17:25??MyElectCourse\Images\Login.GIF

............此處省略32個文件信息