How to Delete the Records from Gridview using CHECKBOX in Asp.net C#

Question

0.00/5 (No votes)

See more:

How to Delete the Records from Gridview using CHECKBOX in Asp.net C#
=======================================================================

Dear Experts,

Please can u suggest me Code..for Deleting records from Gridview using Checkbox in asp.net.

I need to Delete Complete Records as well as multiple records.
Also i need Checkbox in header area as well as Row by row. So i can delete ALL or multiple Records.

Thank u.

Posted 13-May-12 20:24pm

Syed SufiyanUddin

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohamed Mitwalli · Answer 1 · 2012-05-13T20:41:00

Solution 1

Hi ,
Check this
Delete the database data in gridview using checkbox[^]
script running slow error in .net grid checked[^]
Best Regards
M.Mitwalli

Posted 13-May-12 20:41pm

Mohamed Mitwalli

Sandeep Mewara · Answer 2 · 2012-05-13T20:42:00

Solution 2

Have a look at these knowledge-base articles:
Batch Deleting (C#)[^]
Delete Multiple Rows Records Gridview CheckBox Confirmation[^]
Add Checkboxes to ASP.NET GridView Control[^]

Try!

Posted 13-May-12 20:42pm

Sandeep Mewara

Comments

Prasad_Kulkarni 14-May-12 5:32am

Nice one +5!

Sandeep Mewara 14-May-12 8:28am

Thanks.

codeBegin · Answer 3 · 2012-05-13T20:52:00

Solution 3

check this:

http://www.asp.net/web-forms/tutorials/data-access/working-with-batched-data/batch-deleting-cs[^]

http://geekswithblogs.net/dotNETvinz/archive/2009/02/22/gridview-multiple-delete-with-checkbox-and-confirm.aspx[^]

http://aspdotnet-world.blogspot.in/2011/05/deleting-multiple-rows-in-gridview.html[^]

http://forums.asp.net/p/1580034/3981126.aspx[^]

http://www.csharpaspnetarticles.com/2009/04/delete-multiple-rows-gridview-checkbox.html[^]

Posted 13-May-12 20:52pm

codeBegin

Comments

Prasad_Kulkarni 14-May-12 5:32am

Good links! +5

codeBegin 14-May-12 5:39am

Thank you

Prasad_Kulkarni 19-Jul-12 4:50am

You're welcome

vangapally Naveen Kumar · Answer 4 · 2012-05-13T21:06:00

Try Like This
in aspx page:

XML

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"
            AllowPaging="True" PageSize="2" >

      <Columns>

    <%--  <asp:TemplateField HeaderText="Click">
                    <ItemTemplate>
                        <asp:Button runat ="server" ID="btn" Text ="click" OnClick ="btn_click" />
                    </ItemTemplate>
                    </asp:TemplateField> --%>

                <asp:TemplateField HeaderText="Name" HeaderStyle-Font-Size ="Medium" HeaderStyle-Width ="150px" HeaderStyle-Font-Names ="Microsoft Sans Serif" >

                    <ItemTemplate>
                     <div style ="width :150px;font-size :medium ;font-family :Microsoft Sans Serif  ">
                        <asp:Label ID="lblID" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Name") %>'></asp:Label>
                  </div>
                    </ItemTemplate>
                   <EditItemTemplate>
                    <div style ="width :150px;font-size :medium ;font-family :Microsoft Sans Serif  ">
                   <asp:TextBox runat ="server" ID="txtname" Text ='<%#DataBinder.Eval(Container.DataItem,"Name") %>'></asp:TextBox>
                   </div>
                   </EditItemTemplate>

<HeaderStyle Font-Names="Microsoft Sans Serif" Font-Size="Medium" Width="170px"></HeaderStyle>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="Mobile" HeaderStyle-Font-Size ="Medium" HeaderStyle-Width ="150px" HeaderStyle-Font-Names ="Microsoft Sans Serif">
                    <ItemTemplate>
                         <div style ="width :150px;font-size :medium ;font-family :Microsoft Sans Serif  ">
                        <asp:Label ID="lblEmail" runat="server"  Text='<%# DataBinder.Eval(Container.DataItem,"MobileNumber") %>'></asp:Label>
                        </div>
                    </ItemTemplate>
                    <EditItemTemplate >
                     <div style ="width :150px;font-size :medium ;font-family :Microsoft Sans Serif  ">
                   <asp:TextBox runat ="server" ID="txtmob" Text ='<%#DataBinder.Eval(Container.DataItem,"MobileNumber") %>'></asp:TextBox>
                   </div>
                   </EditItemTemplate>

<HeaderStyle Font-Names="Microsoft Sans Serif" Font-Size="Medium" Width="170px"></HeaderStyle>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Address" HeaderStyle-Font-Size ="Medium" HeaderStyle-Width ="170px" HeaderStyle-Font-Names ="Microsoft Sans Serif">
                    <ItemTemplate>
                     <div style ="width :150px;font-size :medium ;font-family :Microsoft Sans Serif  ">
                        <asp:Label ID="lbladdr" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Address") %>'></asp:Label>
                        </div>
                    </ItemTemplate>
                     <EditItemTemplate >
                      <div style ="width :150px;font-size :medium ;font-family :Microsoft Sans Serif  ">
                   <asp:TextBox runat ="server" ID="txtaddr" Text ='<%# Bind(Container.DataItem,"Address") %>'></asp:TextBox>
                   </div>
                   </EditItemTemplate>

<HeaderStyle Font-Names="Microsoft Sans Serif" Font-Size="Medium" Width="170px"></HeaderStyle>
                </asp:TemplateField>
                <asp:TemplateField >
                <ItemTemplate >
                <asp:CheckBox runat ="server" ID="chk1" OnCheckedChanged ="chk1_checked" AutoPostBack ="true" />
                </ItemTemplate>

                </asp:TemplateField>
            <asp:CommandField ButtonType="Button" HeaderText="Edit"
              ControlStyle-Font-Size ="Medium" ControlStyle-Width ="70px" ControlStyle-Font-Names ="Microsoft Sans Serif"
              ShowEditButton="True" >
<ControlStyle Font-Names="Microsoft Sans Serif" Font-Size="Medium" Width="70px"></ControlStyle>
          </asp:CommandField>
          <asp:CommandField ButtonType="Button" HeaderText="Delete"
              ControlStyle-Font-Size ="Medium" ControlStyle-Width ="70px" ControlStyle-Font-Names ="Microsoft Sans Serif"
              ShowDeleteButton="True" >

<ControlStyle Font-Names="Microsoft Sans Serif" Font-Size="Medium" Width="70px"></ControlStyle>
          </asp:CommandField>
          <asp:TemplateField>

          <ItemTemplate>
          <asp:LinkButton Text = '<%# Eval("Name") %>' runat ="server" OnClick ="lnk_click" ID="lnk" CommandArgument ='<%#Eval("Name") %>'></asp:LinkButton>
          </ItemTemplate>
          </asp:TemplateField>
            </Columns>
        </asp:GridView>

in cs page:

VB

Protected Sub GridView2_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView2.RowCommand
       If e.CommandName = "Edit" Then
           Dim i As Integer = e.CommandArgument
           Dim row As GridViewRow = GridView2.Rows(i)

           '            Dim ch As CheckBox
           ch = DirectCast(row.FindControl("chk1"), CheckBox)
           If ch.Checked = True Then
               Response.Write("checked checkbox: &nbsp;" + Convert.ToString(row.RowIndex))    'Here write your delete queary
           Else
               Response.Write(" Not checked checkbox")
           End If

       End If


   End Sub