在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
方法一: 后台代码: 复制代码 代码如下: protected void btn_delete_Click(object sender, EventArgs e) { for (int i = 0; i <this.GridView1.Rows.Count; i++) { int id = Convert.ToInt32(this.GridView1.DataKeys[i].Value); if ((this.GridView1.Rows[i].Cells[0].FindControl("CheckBox1") as CheckBox).Checked == true) { Delete(id); ClientScript.RegisterStartupScript(GetType(),"提示","<script>alert('删除成功!')</script>"); } } this.GridView1.DataBind(); }//删除 private void Delete(int id) { using (SqlConnection conn = new SqlConnection(str)) { conn.Open(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "delete from Notice_Msg where id=@id"; comm.Parameters.Add(new SqlParameter("@id", id)); comm.ExecuteNonQuery(); } } 前台代码: 复制代码 代码如下: <asp:GridView ID="GridView1" runat="server" DataKeyNames="id"> 另外还得添加一列,让其绑定的字段为id,并且把这一列的visable属性设为false 方法二: 后台: 复制代码 代码如下: protected void btn_delete_Click(object sender, EventArgs e) { foreach (GridViewRow row in this.GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox ckb = row.Cells[2].FindControl("CheckBox1") as CheckBox; if (ckb.Checked) { using (SqlConnection sqlCnn = new SqlConnection(str)) { using (SqlCommand sqlCmm = sqlCnn.CreateCommand()) { sqlCmm.CommandText = "delete from Regime_Table where id='" + row.Cells[0].Text + "' "; sqlCnn.Open(); int a= sqlCmm.ExecuteNonQuery(); if (a>0) { ClientScript.RegisterStartupScript(GetType(),"提示","<script>alert('删除成功!')</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "提示", "<script>alert('删除失败!')</script>"); } this.DataBind(); } } } } } } 前台: 复制代码 代码如下: <style type="text/css"> .Hidden { display:none; } </style> <asp:BoundField DataField="id" HeaderText="编号" > <HeaderStyle CssClass="Hidden" /> <ItemStyle CssClass="Hidden" /> </asp:BoundField> 新增加一列,这一列绑定id字段,并且visable属性不能为false,否则取不出值来。 checkbox全选功能: 复制代码 代码如下: <script type="text/jscript"> function change(sender) { var table = document.getElementById("GridView1"); for (var i = 1; i < table.rows.length; i++) { table.rows[i].cells[1].getElementsByTagName("input")[0].checked = sender.checked; } } </script> <HeaderTemplate> <input id="Checkbox2" type="checkbox" onclick="change(this)"/> 全选 </HeaderTemplate> |
请发表评论