.net课程设计(16)

if (conn.State.ToString() == "Closed") conn.Open(); SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn); da.Fill(ds);

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

ddlteacher.DataSource = ds.Tables[0].DefaultView; ddlteacher.DataTextField = "teaName"; ddlteacher.DataValueField = "teaID"; ddlteacher.DataBind();

ddlteacher.SelectedValue = ((HiddenField)e.Row.FindControl("hdfTeacher")).Value; ddlteacher.SelectedItem.Text = ((HiddenField)e.Row.FindControl("hdfTeacher")).Value; } }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; GridViewBind(); }

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; GridViewBind(); }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

string courceID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); string oldTeaID = GridView1.DataKeys[e.RowIndex].Values[1].ToString();

string teaID = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlTeacher")).SelectedValue; string courceName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName")).Text; string courceTime = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtTime")).Text;

string courceAddress = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAddress")).Text;

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

string SqlStr = "update Cource set CourceName='" + courceName + "',teaID='" + teaID + "',courceTime='" + courceTime + "',courceAddress='" + courceAddress + "' where courceID='" + courceID + "' and teaID='" + oldTeaID + "'";

try