The following is the table design from where I am fetching employee records.

employee records
Image 1.

  1. CREATE TABLE [dbo].[Employee](
  2. [Emp_ID] [int] IDENTITY(1,1) NOT NULL,
  3. [Name] [varchar](50) NULL,
  4. [Email] [varchar](500) NULL,
  5. [Designation] [varchar](50) NULL,
  6. [City] [varchar](50) NULL,
  7. [State] [varchar](50) NULL,
  8. [Country] [varchar](50) NULL,
  9. CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
  10. (
  11. [Emp_ID] ASC
  12. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  13. ) ON [PRIMARY]
  15. GO

The following is the data in my table:

table
Image 2.

Now my aspx is:

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4. <html xmlns="http://www.w3.org/1999/xhtml">
  5. <head runat="server">
  6. <title>Delete Multiple Records In Grid View Using Check Box in ASP.NET C#</title>
  7. </head>
  8. <body>
  9. <form id="form1" runat="server">
  10. <div>
  11. <table style="border: solid 15px blue; width: 100%; vertical-align: central;">
  12. <tr>
  13. <td style="padding-left: 50px; padding-top: 20px; padding-bottom: 20px; background-color: skyblue;
  14. font-size: 20pt; color: orangered;">
  15. Delete Multiple Records In Grid View Using Check Box in ASP.NET C#
  16. </td>
  17. </tr>
  18. <tr>
  19. <td style="text-align: left; padding-left: 50px; border: solid 1px red;">
  20. <asp:GridView ID="GridViewEmployee" runat="server" DataKeyNames="Emp_ID" AutoGenerateColumns="False"
  21. Width="90%" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
  22. CellPadding="4" GridLines="Both">
  23. <Columns>
  24. <asp:TemplateField HeaderText="Select">
  25. <ItemTemplate>
  26. <asp:CheckBox ID="chkSelect" runat="server" />
  27. </ItemTemplate>
  28. </asp:TemplateField>
  29. <asp:BoundField DataField="Name" HeaderText="Employee Name" />
  30. <asp:BoundField DataField="Email" HeaderText="Email" />
  31. <asp:BoundField DataField="Designation" HeaderText="Designation" />
  32. <asp:BoundField DataField="City" HeaderText="City" />
  33. <asp:BoundField DataField="State" HeaderText="State" />
  34. <asp:BoundField DataField="Country" HeaderText="Country" />
  35. </Columns>
  36. <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
  37. <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
  38. <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
  39. <RowStyle BackColor="White" ForeColor="#003399" />
  40. <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
  41. </asp:GridView>
  42. </td>
  43. </tr>
  44. <tr>
  45. <td align="right">
  46. <asp:Button ID="btnDeleteRecords" Text="Delete Records" OnClick="btnDeleteRecords_Click"
  47. runat="server" />
  48. </td>
  49. </tr>
  50. </table>
  51. </div>
  52. </form>
  53. </body>
  54. </html>

My aspx.cs code is:

  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data;
  8. using System.Data.SqlClient;
  10. public partial class _Default : System.Web.UI.Page
  11. {
  12. SqlDataAdapter da;
  13. DataSet ds = new DataSet();
  14. DataTable dt = new DataTable();
  16. protected void Page_Load(object sender, EventArgs e)
  17. {
  18. if (!Page.IsPostBack)
  19. this.BindGrid();
  20. }
  22. private void BindGrid()
  23. {
  24. SqlConnection con = new SqlConnection();
  25. ds = new DataSet();
  26. con.ConnectionString = @"Data Source=INDIA\MSSQLServer2k8; Initial Catalog=EmployeeManagement; Uid=sa; pwd=india;";
  27. SqlCommand cmd = new SqlCommand("SELECT * FROM EMPLOYEE", con);
  29. da = new SqlDataAdapter(cmd);
  30. da.Fill(ds);
  31. con.Open();
  32. cmd.ExecuteNonQuery();
  33. con.Close();
  35. if (ds.Tables[0].Rows.Count > 0)
  36. {
  37. GridViewEmployee.DataSource = ds.Tables[0];
  38. GridViewEmployee.DataBind();
  39. }
  40. }
  42. protected void btnDeleteRecords_Click(object sender, EventArgs e)
  43. {
  44. DataTable dt = new DataTable();
  45. dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Name", typeof(string)),
  46. new DataColumn("Email",typeof(string)) });
  49. foreach (GridViewRow row in GridViewEmployee.Rows)
  50. {
  51. if ((row.FindControl("chkSelect") as CheckBox).Checked)
  52. {
  53. int Emp_ID = Convert.ToInt32(GridViewEmployee.DataKeys[row.RowIndex].Value);
  54. using (SqlConnection con = new SqlConnection(@"Data Source=INDIA\MSSQLServer2k8; Initial Catalog=EmployeeManagement; Uid=sa; pwd=india;"))
  55. {
  56. con.Open();
  57. SqlCommand cmd = new SqlCommand("DELETE FROM Employee WHERE Emp_ID=" + Emp_ID, con);
  58. cmd.ExecuteNonQuery();
  59. con.Close();
  60. }
  61. }
  62. }
  64. this.BindGrid();
  65. }
  66. }

Now run the application:

run
Image 3

Now select some records using the checkboxes and click on the "Delete Records" button.

delet record
Image 4.

output
Image 5.