使用commandfield删除、修改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();
????}
總結
以上是生活随笔為你收集整理的使用commandfield删除、修改gridview的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 使用 NOR Flash 中的super
- 下一篇: GridView常用总结