程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> .NET網頁編程 >> ASP.NET >> 關於ASP.NET >> ASP.NET 2.0下含有CheckBox的GridView刪除選定記錄實例

ASP.NET 2.0下含有CheckBox的GridView刪除選定記錄實例

編輯:關於ASP.NET

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>

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   }

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved