Multiple Delete From a gridview in one click.

Introduction

In this Article you can learn how to select the multiple values of row using checkboxes from a Gridview and delete it.

For this tutorial,

 

I have taken example of simple database named “Contact”.

 

I have written my connection string in web.config file under connectionStrings tag. My connection string to connect to the database looks like following.

 

<connectionStrings>

 

  <add name="CRMConnectionString1" connectionString="Data    Source=DataSource1 ;Initial Catalog=CRM;Integrated Security=True;Pooling=False user id=SampleUser; password=SampleUser;"

   providerName="System.Data.SqlClient" />

 

</connectionStrings>

Now Create a page named as Contacts.aspx and add the following code.

 

<form id="form1" runat="server">

    <div style="left:75px; position:absolute; top:45px;">

        <asp:Button ID="btnMultipleDelete" runat="server" Text="Delete"

            onclick="btnMultipleDelete_Click" />

    </div>

 

    <div style="left: 75px; position: absolute; top:75px;">

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ContactId"

            

            EmptyDataText="No Contacts Yet." CellPadding="4"

            ForeColor="#333333" GridLines="None">

            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />

            <Columns>

           

            <asp:TemplateField>

              <ItemTemplate>

                 <asp:CheckBox ID="chkRows"  runat="server" />

              </ItemTemplate>

            </asp:TemplateField>

           

                <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />

                <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />

                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />

                <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />

               

               

            </Columns>

            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />

            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />

            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

            <AlternatingRowStyle BackColor="White" />

        </asp:GridView>

        </div>

       

        <div style="left:75px; position:absolute; top:500px;">

        <asp:Label ID="lblmessage" runat="server"></asp:Label>

        </div>

    </form>

After you write this code in Source view you can see the following Similar output in your Design view.

Now its time to write the C# code

 

Open the page Contacts.aspx.cs

And write following codes.

 

using System.Data.SqlClient;

 

public partial class Contacts : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            BindData();

        }

    }

 

private void BindData()

    {

string connStr = ConfigurationManager.ConnectionStrings["CRMConnectionString1"].ToString();

 

        SqlConnection conn = new SqlConnection(connStr);

 

       

 

SqlDataAdapter dAD = new SqlDataAdapter("SELECT FirstName, LastName, Email, Address FROM Contact ", conn);

 

        dAD.SelectCommand.CommandType = CommandType.Text;

 

        DataSet dSet = new DataSet();

 

        try

        {

            conn.Open();

 

            dAD.Fill(dSet, "Contact");

 

 

        }

        catch (Exception ee)

        {

            lblmessage.Text = ee.Message.ToString();

        }

 

        finally

        {

            GridView1.DataSource = dSet;

            GridView1.DataBind();

 

 

 

 

            conn.Close();

            dSet.Dispose();

            dAD.Dispose();

 

        }

 

    }

The above code Binds your data into the gridview.

After this write the following code  which makes you to select the row using the checkbox and deleting the selected row from gridview.

protected void btnMultipleDelete_Click(object sender, EventArgs e)

    {

 

 

string connStr = ConfigurationManager.ConnectionStrings["CRMConnectionString1"].ToString();

        SqlConnection conn = new SqlConnection(connStr);

 

        SqlCommand cmd = new SqlCommand("DELETE FROM Contact WHERE ContactId = @ContactId ", conn);

 

        cmd.CommandType = CommandType.Text;

 

 

try

        {

            conn.Open();

 

         foreach(GridViewRow r in GridView1.Rows)

            {

               

                CheckBox ck = (CheckBox)r.FindControl("chkRows");

              

 

                if(ck.Checked == true)

                {

       int contactid = Convert.ToInt32(GridView1.DataKeys[r.RowIndex].Value);

                  cmd.Parameters.AddWithValue("@ContactId", contactid);

                  cmd.ExecuteNonQuery();

                }

            }

        }

 

catch (Exception ee)

        {

            lblmessage.Text = ee.Message.ToString();

        }

        finally

        {

            conn.Close();

            cmd.Dispose();

        }

 

        GridView1.EditIndex = -1;

 

        BindData();

    }

}

 

that’s all in coding section. Now its time to view the output.

 

 

After You complete this tutorial. Your output looks similar to:

 

Conclusion

After Selecting the row or checking the multiple row you can delete the data in just one click.

 

Hope you enjoy the coding...