萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> ASP.NET 程式設計

GridView 實現全選/反選與批次刪除完整範例

前端標記

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
  <Columns>
    <asp:TemplateField HeaderText="選擇">
      <ItemTemplate>
        <asp:CheckBox ID="chkSelect" runat="server" />
      </ItemTemplate>
    </asp:TemplateField>
    <asp:BoundField DataField="Comment_ID" HeaderText="ID" />
    <asp:BoundField DataField="Content" HeaderText="內容" />
  </Columns>
</asp:GridView>
<asp:Button ID="btnSelectAll" Text="全選/取消" OnClick="btnSelectAll_Click" runat="server" />
<asp:Button ID="btnDelete" Text="刪除所選" OnClick="btnDelete_Click" runat="server" />

後端代碼

protected void btnSelectAll_Click(object sender, EventArgs e) {
  bool selectAll = (btnSelectAll.Text == "全選/取消");
  foreach (GridViewRow row in GridView1.Rows) {
    var chk = (CheckBox)row.FindControl("chkSelect");
    chk.Checked = selectAll;
  }
  btnSelectAll.Text = selectAll ? "取消全選" : "全選/取消";
}

protected void btnDelete_Click(object sender, EventArgs e) {
  string connStr = ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString;
  using (SqlConnection conn = new SqlConnection(connStr)) {
    conn.Open();
    foreach (GridViewRow row in GridView1.Rows) {
      var chk = (CheckBox)row.FindControl("chkSelect");
      if (chk.Checked) {
        string id = row.Cells[1].Text; // Comment_ID
        using (SqlCommand cmd = new SqlCommand("DELETE FROM Comment WHERE Comment_ID=@id", conn)) {
          cmd.Parameters.AddWithValue("@id", id);
          cmd.ExecuteNonQuery();
        }
      }
    }
  }
  // 重新繫結 GridView
  BindGridView();
}

關鍵改良點

  1. 參數化查詢:防止 SQL Injection,原範例字串拼接極度危險
  2. using 區塊:確保連線/命令正確釋放
  3. 連線共用:刪除迴圈內重複開關連線,改為單一連線批次執行
  4. 狀態同步:按鈕文字切換反映全選/取消狀態

進階:客戶端全選(無 PostBack)

<script type="text/javascript">
  function toggleAll(source) {
    var checkboxes = document.querySelectorAll('#GridView1 input[type=checkbox]');
    checkboxes.forEach(cb => cb.checked = source.checked);
  }
</script>
<asp:CheckBox ID="chkHeader" runat="server" Text="全選" onclick="toggleAll(this)" />

搭配 ClientIDMode="Static" 固定 GridView ID,前端即時操作體驗更佳。

copyright © 萬盛學電腦網 all rights reserved