使用commandfield删除、修改gridview

gridview任务——〉编辑列

添加一个commandField，设置showDeleteBotton和showEditBotton为true

gridview的数据邦定函数

    void data_bind()
    {

        DataSet ds = new DataSet();
        String sqlstr123 = "select 序号,咨询问题,反馈信息 from 咨询表";

        ds = connectDB.dataSet(sqlstr123);

        GridView1.DataSource = ds.Tables[0].DefaultView;

        GridView1.DataBind();
        //conn1.Dispose();
        ds.Dispose();
    }

点击编辑时使选定的datarow处于编辑状态

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
            GridView1.EditIndex = e.NewEditIndex;
            data_bind();

    }

当“编辑”文字变成“更新”时，单击更新

 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

        GridView1.EditIndex = -1;
        TextBox txt =(TextBox) GridView1.Rows[e.RowIndex].Cells[2].Controls[0];
        TextBox txt1 = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0];
        String sqlstr = "update 咨询表 set 咨询问题='" + txt.Text + "' , 反馈信息='" + txt1.Text + "'";
        connectDB.ExecuteUpdate(sqlstr);
        data_bind();
}

 

取消编辑

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        data_bind();
    }