.net课程设计(12)

if (!this.IsPostBack) {

ddlBind();

CourceDetailsShow(); } }

private void ddlBind() {

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string SqlStr = "SELECT teaID,teaName 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); 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 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(); if (sdr.Read()) {

courceName.Text = sdr["courceName"].ToString(); txtName.Text = sdr["courceName"].ToString();

ddlTeacherName.SelectedItem.Text = sdr["teaName"].ToString(); txtTime.Text = sdr["courceTime"].ToString();