Gridview修改功能源代码.docVIP

Gridview修改功能源代码 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 Main_Update : System.Web.UI.Page { Class1 cc = new Class1(); string ss = 计算机科学与软件学院; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bind(); } } //绑定GridView public void bind() { string str2 = select * from 实验管理 where 学院名称= + ss + ; SqlDataAdapter myda = new SqlDataAdapter(str2, cc.mycon); DataSet myds = new DataSet(); cc.mycon.Open(); myda.Fill(myds, 实验管理); GridView1.DataSource = myds; GridView1.DataKeyNames = new string[] { 实验编号 }; GridView1.DataBind(); } //取消编辑行 protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { this.GridView1.EditIndex = -1; bind(); } //编辑行 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { this.GridView1.EditIndex = e.NewEditIndex; bind(); } //更新行 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //string id = Convert.ToString(GridView1.DataKeys)[e.RowIndex].ToString(); string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); string s5 = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl(Xx5)).SelectedValue; string s6 = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl(Xx6)).SelectedValue; string s9 = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl(Xx8)).SelectedValue; string s10 = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl(Xx9)).SelectedValue; string s15 = ((DropDownList)GridView1.Rows[e.RowIndex].FindContr