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
?????目錄???????????0??2018-08-11?21:16??MyElectCourse\App_Data\
?????文件????10485760??2007-03-05?17:25??MyElectCourse\App_Data\ASPNETDB.MDF
?????文件??????516096??2007-03-05?17:25??MyElectCourse\App_Data\aspnetdb_log.ldf
?????目錄???????????0??2018-08-11?21:16??MyElectCourse\Controls\
?????文件????????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
?????目錄???????????0??2018-08-11?21:16??MyElectCourse\DB_51aspx\
?????文件?????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
?????目錄???????????0??2018-08-11?21:16??MyElectCourse\Images\
?????文件????????1265??2007-03-05?17:25??MyElectCourse\Images\ADD.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
............此處省略26個文件信息