ASP.NET

Deleting Multiple Records From Gridview Using ASP.Net C#

 Background

There is often a need to delete one or more records from a GridView, so by considering this requirement I have decided to write this article. Now before creating the application, let us create a table named employee in a database from which we show the records in a GridView, the table has the following fields (shown in the following image):
 
 
I hope you have created the same type of table.
 
Now create the project as:
  1. "Start" - "All Programs" - "Microsoft Visual Studio 2010".
  2. "File" - "New Project" - "C#" - "Empty Project" (to avoid adding a master page).
  3. Give the project the name "DeletingMultiRec" or another as you wish and specify the location.
  4. Then right-click on Solution Explorer then seelct "Add New Item" - "Default.aspx" page.
  5. Add one button, one label and a GridView.

Default.aspx source code.

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>  
  2.   
  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></title>  
  7. </head>  
  8. <body bgcolor="silver">  
  9.     <form id="form1" runat="server">  
  10.     <br />  
  11.     <h2 style="color: #808000; font-size: x-large; font-weight: bolder;">  
  12.         Article by Vithal Wadje</h2>  
  13.     <br />  
  14.     <div>  
  15.         <asp:GridView ID="GrdEmpDetails" runat="server" AutoGenerateColumns="False" Font-Names="Arial"  
  16.             Font-Size="11pt" AlternatingRowStyle-BackColor="#C2D69B" HeaderStyle-BackColor="green"  
  17.             AllowPaging="True" OnPageIndexChanging="OnPaging" DataKeyNames="Id" CellPadding="4"  
  18.             ForeColor="#333333" GridLines="None">  
  19.             <Columns>  
  20.                 <asp:TemplateField>  
  21.                     <HeaderTemplate>  
  22.                         <asp:Label runat="server" Text="Delete All "></asp:Label>  
  23.                         <asp:CheckBox ID="chkAll" runat="server" onclick="checkAll(this);" />  
  24.                     </HeaderTemplate>  
  25.                     <ItemTemplate>  
  26.                         <asp:CheckBox ID="chk" runat="server" onclick="Check_Click(this)" />  
  27.                     </ItemTemplate>  
  28.                 </asp:TemplateField>  
  29.                 <asp:BoundField ItemStyle-Width="150px" DataField="Name" HeaderText=" Name">  
  30.                     <ItemStyle Width="150px"></ItemStyle>  
  31.                 </asp:BoundField>  
  32.                 <asp:BoundField ItemStyle-Width="150px" DataField="City" HeaderText="City">  
  33.                     <ItemStyle Width="150px"></ItemStyle>  
  34.                 </asp:BoundField>  
  35.                 <asp:BoundField ItemStyle-Width="150px" DataField="Address" HeaderText="Address">  
  36.                     <ItemStyle Width="150px"></ItemStyle>  
  37.                 </asp:BoundField>  
  38.                 <asp:BoundField ItemStyle-Width="150px" DataField="Designation" HeaderText="Designation">  
  39.                     <ItemStyle Width="150px"></ItemStyle>  
  40.                 </asp:BoundField>  
  41.             </Columns>  
  42.             <AlternatingRowStyle BackColor="White" />  
  43.             <EditRowStyle BackColor="#7C6F57" />  
  44.             <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />  
  45.             <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White"></HeaderStyle>  
  46.             <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />  
  47.             <RowStyle BackColor="#E3EAEB" />  
  48.             <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />  
  49.             <SortedAscendingCellStyle BackColor="#F8FAFA" />  
  50.             <SortedAscendingHeaderStyle BackColor="#246B61" />  
  51.             <SortedDescendingCellStyle BackColor="#D4DFE1" />  
  52.             <SortedDescendingHeaderStyle BackColor="#15524A" />  
  53.         </asp:GridView>  
  54.         <asp:HiddenField ID="hdncnt" runat="server" Value="0" />  
  55.         <asp:Button ID="btnDelete" runat="server" Text="Delete" OnClientClick="return ConfirmDelete();"  
  56.             OnClick="btnDelete_Click" />  
  57.     </div>  
  58.     </form>  
  59. </body>  
  60. </html> 

Now, create the following function in the default.aspx.cs page to bind the GridView:
  1. private void BindGrid()  
  2.    {  
  3.        connection();  
  4.        string query = "select * from Employee";  
  5.        SqlDataAdapter da = new SqlDataAdapter(query, con);  
  6.        DataTable dt = new DataTable();  
  7.        da.Fill(dt);  
  8.        GrdEmpDetails.DataSource = dt;  
  9.        GrdEmpDetails.DataBind();       
  10.   
  11.    } 
 Now write the following function for deleting records:
  1. private void DeleteRecord(string SelectedId)  
  2.   {  
  3.       connection();  
  4.       query = "delete from Employee " + "where Id=@Id";  
  5.       com = new SqlCommand(query, con);  
  6.       com.Parameters.AddWithValue("@Id", SelectedId);  
  7.       com.ExecuteNonQuery();  
  8.       con.Close();  
  9.   } 
 Create the following function for selecting one or more records:
  1. private void SelectRecords()  
  2.    {  
  3.        int currentSelectedRec = 0;  
  4.   
  5.        CheckBox chkAll = (CheckBox)GrdEmpDetails.HeaderRow.Cells[0].FindControl("chkAll");  
  6.        chkAll.Checked = true;  
  7.   
  8.        ArrayList arr = (ArrayList)ViewState["RecordsTobeDeleted"];  
  9.   
  10.        for (int i = 0; i < GrdEmpDetails.Rows.Count; i++)  
  11.        {  
  12.   
  13.            CheckBox chk = (CheckBox)GrdEmpDetails.Rows[i].Cells[0].FindControl("chk");  
  14.   
  15.            if (chk != null)  
  16.            {  
  17.                chk.Checked = arr.Contains(GrdEmpDetails.DataKeys[i].Value);  
  18.   
  19.                if (!chk.Checked)  
  20.                {  
  21.                    chkAll.Checked = false;  
  22.                }  
  23.   
  24.                else  
  25.                {   
  26.                    currentSelectedRec++;  
  27.                }  
  28.            }  
  29.   
  30.        }  
  31.        hdncnt.Value = (arr.Count - currentSelectedRec).ToString();  
  32.   
  33.    } 
 Now write the following code for the button delete click:
  1. protected void btnDelete_Click(object sender, EventArgs e)  
  2.    {  
  3.        int count = 0;  
  4.        SelectRecords();  
  5.        GrdEmpDetails.AllowPaging = false;  
  6.        GrdEmpDetails.DataBind();  
  7.        ArrayList arr = (ArrayList)ViewState["RecordsTobeDeleted"];  
  8.        count = arr.Count;  
  9.        for (int i = 0; i < GrdEmpDetails.Rows.Count; i++)  
  10.        {  
  11.   
  12.            if (arr.Contains(GrdEmpDetails.DataKeys[i].Value))  
  13.            {  
  14.   
  15.                DeleteRecord(GrdEmpDetails.DataKeys[i].Value.ToString());  
  16.   
  17.                arr.Remove(GrdEmpDetails.DataKeys[i].Value);  
  18.   
  19.            }  
  20.   
  21.        }  
  22.   
  23.        ViewState["RecordsTobeDeleted"] = arr;  
  24.        hdncnt.Value = "0";  
  25.        GrdEmpDetails.AllowPaging = true;  
  26.        BindGrid();  
  27.        alertmsg(count);  
  28.    } 
Now the combined code of all the above will look like:
  1. using System;  
  2. using System.Web.UI.WebControls;  
  3. using System.Configuration;  
  4. using System.Data;  
  5. using System.Data.SqlClient;  
  6. using System.Text;  
  7. using System.Collections;  
  8.   
  9. public partial class _Default : System.Web.UI.Page  
  10. {  
  11.     private SqlConnection con;  
  12.     private SqlCommand com;  
  13.     private string constr, query;  
  14.     private void connection()  
  15.     {  
  16.         constr = ConfigurationManager.ConnectionStrings["ConnMultiRec"].ToString();  
  17.         con = new SqlConnection(constr);  
  18.         con.Open();  
  19.   
  20.     }  
  21.   
  22.     protected void Page_Load(object sender, EventArgs e)  
  23.     {  
  24.         if (IsPostBack == true)  
  25.         {  
  26.             GetData();  
  27.   
  28.         }  
  29.         BindGrid();  
  30.   
  31.     }  
  32.   
  33.     private void BindGrid()  
  34.     {  
  35.         connection();  
  36.         string query = "select * from Employee";  
  37.         SqlDataAdapter da = new SqlDataAdapter(query, con);  
  38.         DataTable dt = new DataTable();  
  39.         da.Fill(dt);  
  40.         GrdEmpDetails.DataSource = dt;  
  41.         GrdEmpDetails.DataBind();  
  42.   
  43.     }  
  44.   
  45.     private void GetData()  
  46.     {  
  47.   
  48.         ArrayList arr;  
  49.   
  50.         if (ViewState["RecordsTobeDeleted"] != null)  
  51.         {  
  52.             arr = (ArrayList)ViewState["RecordsTobeDeleted"];  
  53.   
  54.         }  
  55.         else  
  56.         {  
  57.   
  58.             arr = new ArrayList();  
  59.         }  
  60.   
  61.   
  62.         CheckBox chkAll = (CheckBox)GrdEmpDetails.HeaderRow.Cells[0].FindControl("chkAll");  
  63.         for (int i = 0; i < GrdEmpDetails.Rows.Count; i++)  
  64.         {  
  65.   
  66.             if (chkAll.Checked)  
  67.             {  
  68.   
  69.                 if (!arr.Contains(GrdEmpDetails.DataKeys[i].Value))  
  70.                 {  
  71.   
  72.                     arr.Add(GrdEmpDetails.DataKeys[i].Value);  
  73.   
  74.                 }  
  75.   
  76.             }  
  77.   
  78.             else  
  79.             {  
  80.   
  81.                 CheckBox chk = (CheckBox)GrdEmpDetails.Rows[i]  
  82.   
  83.                                    .Cells[0].FindControl("chk");  
  84.   
  85.                 if (chk.Checked)  
  86.                 {  
  87.   
  88.                     if (!arr.Contains(GrdEmpDetails.DataKeys[i].Value))  
  89.                     {  
  90.   
  91.                         arr.Add(GrdEmpDetails.DataKeys[i].Value);  
  92.   
  93.                     }  
  94.   
  95.                 }  
  96.   
  97.   
  98.                 else  
  99.                 {  
  100.   
  101.                     if (arr.Contains(GrdEmpDetails.DataKeys[i].Value))  
  102.                     {  
  103.   
  104.                         arr.Remove(GrdEmpDetails.DataKeys[i].Value);  
  105.   
  106.                     }  
  107.   
  108.                 }  
  109.   
  110.             }  
  111.   
  112.         }  
  113.   
  114.   
  115.         ViewState["RecordsTobeDeleted"] = arr;  
  116.   
  117.     }  
  118.   
  119.     private void SelectRecords()  
  120.     {  
  121.         int currentSelectedRec = 0;  
  122.   
  123.         CheckBox chkAll = (CheckBox)GrdEmpDetails.HeaderRow.Cells[0].FindControl("chkAll");  
  124.         chkAll.Checked = true;  
  125.   
  126.         ArrayList arr = (ArrayList)ViewState["RecordsTobeDeleted"];  
  127.   
  128.         for (int i = 0; i < GrdEmpDetails.Rows.Count; i++)  
  129.         {  
  130.   
  131.             CheckBox chk = (CheckBox)GrdEmpDetails.Rows[i].Cells[0].FindControl("chk");  
  132.   
  133.             if (chk != null)  
  134.             {  
  135.                 chk.Checked = arr.Contains(GrdEmpDetails.DataKeys[i].Value);  
  136.   
  137.                 if (!chk.Checked)  
  138.                 {  
  139.                     chkAll.Checked = false;  
  140.                 }  
  141.   
  142.                 else  
  143.                 {  
  144.   
  145.                     currentSelectedRec++;  
  146.   
  147.                 }  
  148.   
  149.             }  
  150.   
  151.         }  
  152.         hdncnt.Value = (arr.Count - currentSelectedRec).ToString();  
  153.   
  154.     }  
  155.   
  156.     protected void OnPaging(object sender, GridViewPageEventArgs e)  
  157.     {  
  158.         GrdEmpDetails.PageIndex = e.NewPageIndex;  
  159.         GrdEmpDetails.DataBind();  
  160.         SelectRecords();  
  161.     }  
  162.   
  163.     protected void btnDelete_Click(object sender, EventArgs e)  
  164.     {  
  165.         int count = 0;  
  166.         SelectRecords();  
  167.         GrdEmpDetails.AllowPaging = false;  
  168.         GrdEmpDetails.DataBind();  
  169.         ArrayList arr = (ArrayList)ViewState["RecordsTobeDeleted"];  
  170.         count = arr.Count;  
  171.         for (int i = 0; i < GrdEmpDetails.Rows.Count; i++)  
  172.         {  
  173.   
  174.             if (arr.Contains(GrdEmpDetails.DataKeys[i].Value))  
  175.             {  
  176.   
  177.                 DeleteRecord(GrdEmpDetails.DataKeys[i].Value.ToString());  
  178.   
  179.                 arr.Remove(GrdEmpDetails.DataKeys[i].Value);  
  180.   
  181.             }  
  182.   
  183.         }  
  184.   
  185.         ViewState["RecordsTobeDeleted"] = arr;  
  186.         hdncnt.Value = "0";  
  187.         GrdEmpDetails.AllowPaging = true;  
  188.         BindGrid();  
  189.         alertmsg(count);  
  190.     }  
  191.   
  192.     private void DeleteRecord(string SelectedId)  
  193.     {  
  194.   
  195.         connection();  
  196.         query = "delete from Employee " + "where Id=@Id";  
  197.         com = new SqlCommand(query, con);  
  198.         com.Parameters.AddWithValue("@Id", SelectedId);  
  199.         com.ExecuteNonQuery();  
  200.         con.Close();  
  201.     }  
  202.   
  203.     private void alertmsg(int SelectedReccount)  
  204.     {  
  205.         StringBuilder sb = new StringBuilder();  
  206.         sb.Append("<script type = 'text/javascript'>");  
  207.         sb.Append("alert('");  
  208.         sb.Append(SelectedReccount.ToString() + "  " + "   ");  
  209.         sb.Append("Records are  deleted.');");  
  210.         sb.Append("</script>");  
  211.         ClientScript.RegisterStartupScript(this.GetType(), "script", sb.ToString());  
  212.     }  
  213. } 
Now run the application; the UI will look like as in the following:
 
 
Now select some records and click on the delete button, after deleting records the following message is shown.
 
 
 
Now from all the preceding examples, we have learned how to delete one or more records from a GridView. I hope you have enjoyed this article while coding.
Note:
  • For detailed code please download the Zip file attached above.
  • Don't forget to create the text file for storing votes.
Summary

I hope this article is useful. If you have any suggestion regarding this article then please contact me.
 

Up Next
    Ebook Download
    View all
    Learn
    View all
    Get Started

    You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.

    Become a sharper developer and jumpstart your career.

    Basic

    $0

    $

    . 00

    monthly

    For Basic members:

    • Standard Profile
    • Access learning courses
    • Access free e-books
    • 1x point
    Premium

    $20

    $

    . 00

    monthly

    For Premium members:

    • Earn 2x reward points
    • Premium profile with Verified check
    • Premium Avatar with status update
    • Learning courses
    • Unlimited Certifications and badges on profile
    • Unlimited Book downloads
    • Access to Premium content
    • Online Training
    • Unlimited PDF conversions and downloads
    • Professional Resume Writing
    • Interview Preparations Guide
    • 25 messages per month
    • 1 "Kodzu" avatar, basic
    Elite

    $45

    $

    . 00

    monthly

    For Elite members:

    • Bundle E-books
    • Access to all Learn Series
    • Unlimited Apply Jobs