ASP.NET2.0下含有CheckBox的GridView删除选定记录实例!
1 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" PageSize="5"
2 Width="726px" AllowPaging="True" AllowSorting="True"
3 DataKeyNames="DB1_1,DB1_2" OnRowDeleting="GridView1_RowDeleting" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound" OnSorting="GridView1_Sorting" Height="279px" >
4 <Columns>
5 <asp:TemplateField HeaderText="序号" >
6 <ItemTemplate>
7 <%# this.GridView1.PageIndex * this.GridView1.PageSize + this.GridView1.Rows.Count + 1%>
8 </ItemTemplate>
9 </asp:TemplateField>
10 <asp:TemplateField HeaderText="选择" >
11 <ItemTemplate>
12 <asp:CheckBox ID="chkSelect" runat="server" ></asp:CheckBox>
13 </ItemTemplate>
14 </asp:TemplateField>
15 <asp:TemplateField HeaderText="操作" ShowHeader="False">
16 <ItemTemplate>
17 <asp:LinkButton ID="lbtnDelete" runat="server" CausesValidation="False" CommandName="Delete"
18 Text="删除" OnClientClick="return confirm('确认要删除吗?');"></asp:LinkButton>
19 </ItemTemplate>
20 </asp:TemplateField>
21 </Columns>
22 <AlternatingRowStyle BackColor="Aquamarine" />
23 </asp:GridView>
2 Width="726px" AllowPaging="True" AllowSorting="True"
3 DataKeyNames="DB1_1,DB1_2" OnRowDeleting="GridView1_RowDeleting" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound" OnSorting="GridView1_Sorting" Height="279px" >
4 <Columns>
5 <asp:TemplateField HeaderText="序号" >
6 <ItemTemplate>
7 <%# this.GridView1.PageIndex * this.GridView1.PageSize + this.GridView1.Rows.Count + 1%>
8 </ItemTemplate>
9 </asp:TemplateField>
10 <asp:TemplateField HeaderText="选择" >
11 <ItemTemplate>
12 <asp:CheckBox ID="chkSelect" runat="server" ></asp:CheckBox>
13 </ItemTemplate>
14 </asp:TemplateField>
15 <asp:TemplateField HeaderText="操作" ShowHeader="False">
16 <ItemTemplate>
17 <asp:LinkButton ID="lbtnDelete" runat="server" CausesValidation="False" CommandName="Delete"
18 Text="删除" OnClientClick="return confirm('确认要删除吗?');"></asp:LinkButton>
19 </ItemTemplate>
20 </asp:TemplateField>
21 </Columns>
22 <AlternatingRowStyle BackColor="Aquamarine" />
23 </asp:GridView>
1 <asp:CheckBox ID="chkSelectAll" runat="server" Text="全部选中" OnCheckedChanged="chkSelectAll_CheckedChanged" AutoPostBack="True" ></asp:CheckBox>
2 <asp:Button ID="btnDelete" runat="server" Text="删除" OnClick="btnDelete_Click" />
2 <asp:Button ID="btnDelete" runat="server" Text="删除" OnClick="btnDelete_Click" />
1 protected void btnDelete_Click(object sender, EventArgs e)
2 {
3 string strDelete = "";
4 for (int i = 0; i < this.GridView1.Rows.Count; i++)
5 {
6 string Label;
7 bool isChecked = ((CheckBox)GridView1.Rows[i].FindControl("chkSelect")).Checked;
8 Label = ((Label)GridView1.Rows[i].FindControl("labXH")).Text;
9 if (isChecked)
10 {
11 strDelete = "DB1_1" + "=" + Label;
12 }
13 }
14 conn.RunSql("Delete from DB1 where " + strDelete
15 this.chkSelectAll.Checked = false;
16 GridViewBind();
17 }
18
19 protected void chkSelectAll_CheckedChanged(object sender, EventArgs e)
20 {
21 //遍历GridView行获取CheckBox属性
22 for (int i = 0; i < this.GridView1.Rows.Count; i++)
23 {
24 ((CheckBox)GridView1.Rows[i].FindControl("chkSelect")).Checked = this.chkSelectAll.Checked;
25 }
26 }
2 {
3 string strDelete = "";
4 for (int i = 0; i < this.GridView1.Rows.Count; i++)
5 {
6 string Label;
7 bool isChecked = ((CheckBox)GridView1.Rows[i].FindControl("chkSelect")).Checked;
8 Label = ((Label)GridView1.Rows[i].FindControl("labXH")).Text;
9 if (isChecked)
10 {
11 strDelete = "DB1_1" + "=" + Label;
12 }
13 }
14 conn.RunSql("Delete from DB1 where " + strDelete
15 this.chkSelectAll.Checked = false;
16 GridViewBind();
17 }
18
19 protected void chkSelectAll_CheckedChanged(object sender, EventArgs e)
20 {
21 //遍历GridView行获取CheckBox属性
22 for (int i = 0; i < this.GridView1.Rows.Count; i++)
23 {
24 ((CheckBox)GridView1.Rows[i].FindControl("chkSelect")).Checked = this.chkSelectAll.Checked;
25 }
26 }