GridView全选和批量删除
来源:互联网 发布:金山手机数据恢复大师 编辑:程序博客网 时间:2024/06/05 21:58
//全选 protected void CheckBox2_CheckedChanged(object sender, EventArgs e) { for (int i = 0; i <= GridView1.Rows.Count-1;i++ ) { CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1"); if (CheckBox2.Checked == true) { cbox.Checked = true; } else { cbox.Checked = false; } } } //全部删除 protected void btnAllDelete_Click(object sender, EventArgs e) { for (int i = 0; i <= GridView1.Rows.Count - 1; i++) { CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1"); if (cbox.Checked == true) { string sqlstr = "delete from tb_Member where MemberID='"+GridView1.DataKeys[i].Value+"'"; SqlConnection myConn = GetConnection(); SqlCommand myCmd = new SqlCommand(sqlstr, myConn); myConn.Open(); myCmd.ExecuteNonQuery(); myConn.Close(); } } bind(); } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { CheckBox2.Checked = false; string sqlstr = "delete from tb_Member where MemberID=" + Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString()); SqlConnection myConn = GetConnection(); SqlCommand myCmd = new SqlCommand(sqlstr, myConn); myConn.Open(); myCmd.ExecuteNonQuery(); myConn.Close(); bind(); }
- GridView全选和批量删除
- GridView中实现全选批量删除数据
- GridView批量删除、全选 + TreeView+复选框
- GridView批量删除 GridView添加主键 全选记录 确认删除
- GridView中实现全选完成批量审批或批量删除
- GridView中实现全选完成批量审批或批量删除
- GridView批量删除记录、全选及弹出确认对话框(引用)
- 在GridView实现批量删除记录、CheckBox全选
- GridView实用示例代码:全选 反选 批量删除
- GridView批量删除记录、全选及弹出确认对话框
- asp.net中GridView全选后进行批量删除
- GridView批量删除记录、全选及弹出确认对话框
- 全选和反选及批量删除
- 全选反选和批量删除
- Gridview 全选 删除 操作
- GridView全选及删除
- 全选与批量删除
- angularJS全选/批量删除
- CEdit控件限制只能输入特定字符的方法
- 动态更改itemRenderer
- java高级特性
- Fortran 组合逻辑运算符
- 不靠谱的生命三角
- GridView全选和批量删除
- 使用AdminClient 连接Websphere 7
- DevExpress控件之comboBoxEx(comboBoxEx1.SelectedText与comboBoxEx1.SelectedItem的区别)
- ibatis查询出结果持久化时遇到的问题
- 渔夫的故事
- 纠结
- 树的概念
- 摘抄感叹
- GDI+从资源中加载图片