1 public partial class courseDetail : System.Web.UI.Page
 2 {
 3     protected void Page_Load(object sender, EventArgs e)
 4     {
 5         if (!this.IsPostBack)
 6         {
 7             CourceDetailsShow();
 8         }
 9     }
10 
11     //显示课程信息
12     private void CourceDetailsShow()
13     {
14         string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;   //取出连接字符串
15        
16         string SqlStr = "SELECT Cource.*,Teacher.teaName from Cource,Teacher where Cource.teaID=Teacher.teaID and Cource.courceID='" + Request["courceID"].ToString() + "' and Cource.teaID='" + Request["teaID"].ToString() + "'";
17         SqlConnection conn = new SqlConnection(connStr);    //创建连接对象
18         try
19         {
20             if (conn.State.ToString() == "Closed")          //连接如果关闭，打开
21                 conn.Open();
22             SqlCommand cmd=new SqlCommand(SqlStr, conn);    //创建操作数据库对象
23             SqlDataReader sdr = cmd.ExecuteReader();        //执行查询，将结果放到DataReader对象
24             if (sdr.Read())                                 //如果查询到课程信息，显示
25             {
26                 courceNameF.Text = sdr["courceName"].ToString();
27                 courceName.Text = sdr["courceName"].ToString();
28                 teaName.Text = sdr["teaName"].ToString();
29                 courceTime.Text = sdr["courceTime"].ToString();
30                 courceAddress.Text = sdr["courceAddress"].ToString();
31                 courceDetails.Text = sdr["courceInfo"].ToString();
32             }
33             else
34             {
35                 Response.Write("数据库错误，没查询到该门课程！");
36                 Response.End();
37             }
38         }
39         catch (Exception ex)                                //异常处理
40         {
41             Response.Write("数据库错误，错误原因：" + ex.Message);
42             Response.End();
43         }
44         finally
45         {
46             if (conn.State.ToString() == "Open")            //如果连接打开，关闭
47                 conn.Close();
48         }  
49     }
50 }