当前文件路径：MyElectCourse/courseDetail.aspx.cs

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