.net课程设计(13)

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.ToString() == "Open") conn.Close(); } }

protected void imgBtnConfirm_Click(object sender, ImageClickEventArgs e) {

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string

SqlStr

=

"update

Cource

set

courceName='"+txtName.Text+"',teaID='"+ddlTeacherName.SelectedValue+"',courceTime='"+txtTime.Text+"',courceAddress='"+txtAddress.Text+"',courceInfo='"+txtDetails.Text+"' where courceID='" + Request["courceID"].ToString() + "' and teaID='" + Request["teaID"].ToString() + "'";

SqlConnection conn = new SqlConnection(connStr); try {

if (conn.State.ToString() == "Closed") conn.Open();

SqlCommand cmd = new SqlCommand(SqlStr, conn); int flag = cmd.ExecuteNonQuery(); if (flag>0) {

lblMessage.Text = "成功修改课程信息！"; } else {

Response.Write("数据库错误，没查询到该门课程！"); Response.End(); }