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>
1
4                             </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"  />

 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     }