gridview中的删除 更新操作

 protected void bind()  //绑定数据
    {
        DataTable rs = ConnDare.SqlGetDataTable(Base_Query_Sql);
        this.GridView1.DataSource = rs;
        this.GridView1.DataKeyNames = new string[] { "id" };
        this.GridView1.DataBind();
    }
   
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;  //关闭编辑状态 -1时为非编辑状态
        bind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int ab = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);//datakeys 为之前给gridview传的参数  e.rowindex为当前行的索引
        string Slqstring = "delete from T_jzbz where id=" + ab;
        ConnDare.SqlGetDataTable(Slqstring);  //控件中 执行sql语句
        bind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;启动编辑状态 不为-1时为编辑状态
        bind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string Slqstring = @"update T_jzbz set bm='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString().Trim() +
            "',jzbz='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString().Trim() +
            //"',BZ='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString().Trim() +
          "' where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; // 去gridview中每行更改的值 写回数据库
        ConnDare.SqlGetDataTable(Slqstring);
        GridView1.EditIndex = -1; //关闭编辑状态
        bind();
    }