?? coursedetail.aspx.cs
字號:
?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 courseDetail : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
CourceDetailsShow();
}
}
//顯示課程信息
private void CourceDetailsShow()
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; //取出連接字符串
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() + "'";
SqlConnection conn = new SqlConnection(connStr); //創建連接對象
try
{
if (conn.State.ToString() == "Closed") //連接如果關閉,打開
conn.Open();
SqlCommand cmd=new SqlCommand(SqlStr, conn); //創建操作數據庫對象
SqlDataReader sdr = cmd.ExecuteReader(); //執行查詢,將結果放到DataReader對象
if (sdr.Read()) //如果查詢到課程信息,顯示
{
courceNameF.Text = sdr["courceName"].ToString();
courceName.Text = sdr["courceName"].ToString();
teaName.Text = sdr["teaName"].ToString();
courceTime.Text = sdr["courceTime"].ToString();
courceAddress.Text = sdr["courceAddress"].ToString();
courceDetails.Text = sdr["courceInfo"].ToString();
}
else
{
Response.Write("數據庫錯誤,沒查詢到該門課程!");
Response.End();
}
}
catch (Exception ex) //異常處理
{
Response.Write("數據庫錯誤,錯誤原因:" + ex.Message);
Response.End();
}
finally
{
if (conn.State.ToString() == "Open") //如果連接打開,關閉
conn.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -