ltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34False34 CellPadding34434 ForeColor3433333334 GridLines34None34 Class34table tablestriped tablebordered tablehover34 onrowcancelingedit34GridView1RowCancelingEdit34 onrowediting34GridView1RowEditing34 onrowupdating34GridView1RowUpdating34 onrowdatabound34GridView1RowDataBound34gt l

Delete multiple rows in GridView with CheckBox selection and with confirmation using C# and VB.Net in ASP.Net

smile

SOLVED CLOSED ACTIVE ANSWERED
User: smile
Posted: on Oct 31, 2017 01:55 AM
Forum: Data Controls
Answer: 3
Views: 8952

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" ForeColor="#333333" GridLines="None"  Class="table table-striped table-bordered table-hover" 
            onrowcancelingedit="GridView1_RowCancelingEdit" 
            onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" 
            onrowdatabound="GridView1_RowDataBound">
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <Columns>
               
                <asp:TemplateField>
                    <HeaderTemplate>
                      <asp:CheckBox ID="checkAll" runat="server" onclick = "checkAll(this);" />
                    </HeaderTemplate>
                   <ItemTemplate>
                     <asp:CheckBox ID="CheckBox1" runat="server" onclick = "Check_Click(this)" />
                   </ItemTemplate>
                </asp:TemplateField>
               
               <asp:TemplateField HeaderText="Reg No.">
               <ItemTemplate >
                   <asp:Label ID="lbl_AdNo" runat="server" Text='<%# Eval("AdmissionNo") %>' ></asp:Label>
               </ItemTemplate>
               </asp:TemplateField>

               <asp:TemplateField HeaderText="Student Name">
                <ItemTemplate >
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("SName") %>'></asp:Label>
                </ItemTemplate>               
                </asp:TemplateField>

                 <asp:TemplateField HeaderText="Father Name">
                <ItemTemplate >
                    <asp:Label ID="Label2" runat="server" Text='<%# Eval("FName") %>'></asp:Label>
                </ItemTemplate>               
                </asp:TemplateField>
                 
                <asp:TemplateField HeaderText="Subject Name" >
                <ItemTemplate >
                  <asp:Label ID="Label3" runat="server" Text='<%# Eval("SubjectName") %>' Width="75"></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>

                    <asp:TemplateField HeaderText="Total Marks" >
                <ItemTemplate >
                  <asp:Label ID="Label4" runat="server" Text='<%# Eval("MaxMarks") %>' Width="75"></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>

                <asp:TemplateField HeaderText="Pass Marks" >
                <ItemTemplate>
                    <asp:Label ID="Label5" runat="server" Text='<%# Eval("PassMarks") %>'></asp:Label>
                </ItemTemplate>
                </asp:TemplateField>

               <asp:TemplateField HeaderText="Marks" >
                <ItemTemplate>
                    <asp:Label ID="Label6" runat="server" Text='<%# Eval("Marks") %>'></asp:Label>
                </ItemTemplate>
                <EditItemTemplate >
                    <asp:TextBox ID="txtMarks" runat="server" Text='<%# Eval("Marks") %>' Width="75"></asp:TextBox>
                </EditItemTemplate>
                </asp:TemplateField>

               <asp:TemplateField HeaderText="Edit" ShowHeader="false">
                    <ItemTemplate>
                        <asp:LinkButton ID="btnedit" runat="server" CommandName="Edit" Text="Edit" ></asp:LinkButton>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:LinkButton ID="btnupdate" runat="server" CommandName="Update" Text="Update" ></asp:LinkButton>
                        <asp:LinkButton ID="btncancel" runat="server" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                    </EditItemTemplate>
                  </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#CCCCCC" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>

screeen shot

and I want to delete selected record and code is :

protected void btnDelete_Click(object sender, EventArgs e)
    {
        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
        {
            GridViewRow row = GridView1.Rows[i];
            CheckBox Chbox = (CheckBox)row.FindControl("CheckBox1");
            if (Chbox.Checked == true)
            {
                select++;
            }
        }

        if (select == 0)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please Select Record to Delete');", true);
            
        }

        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
        {

            string AdNo = GridView1.Rows[i].Cells[1].Text;
           // Label lbl_AdNo = GridView1.Rows[e.RowIndex].FindControl("lbl_AdNo") as Label;
            GridViewRow row = GridView1.Rows[i];
            CheckBox Chbox = (CheckBox)row.FindControl("CheckBox1");
            if (Chbox.Checked == true)
            {
                con = new SqlDbConnect();
                con.SqlQuery("delete from tblSetMarks where AdmissionNo=@AdNo");
                con.Cmd.Parameters.AddWithValue("@AdNo", AdNo);
                con.NonQueryEx();
               // GridView1.Visible = false;
                
            }
        }
        ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Student's Marks Deteleted Successfully');", true);
        this.BindSectionGrid(); 
    }

This is not deleting the record what is the error in the code

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Oct 31, 2017 02:09 AM
Modified: on Oct 31, 2017 02:12 AM
Report

smile says:
protected void btnDelete_Click(object sender, EventArgs e)

    {

        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

        {

            GridViewRow row = GridView1.Rows[i];

            CheckBox Chbox = (CheckBox)row.FindControl("CheckBox1");

            if (Chbox.Checked == true)

            {

                select++;

            }

        }

        if (select == 0)

        {

            ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please Select Record to Delete');", true);



        }

        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

        {

            string AdNo = GridView1.Rows[i].Cells[1].Text;

           // Label lbl_AdNo = GridView1.Rows[e.RowIndex].FindControl("lbl_AdNo") as Label;

            GridViewRow row = GridView1.Rows[i];

            CheckBox Chbox = (CheckBox)row.FindControl("CheckBox1");

            if (Chbox.Checked == true)

            {

                con = new SqlDbConnect();

                con.SqlQuery("delete from tblSetMarks where AdmissionNo=@AdNo");

                con.Cmd.Parameters.AddWithValue("@AdNo", AdNo);

                con.NonQueryEx();

               // GridView1.Visible = false;



            }

        }

        ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Student's Marks Deteleted Successfully');", true);

        this.BindSectionGrid();

    }

Replace the above with the below code.

protected void btnDelete_Click(object sender, EventArgs e)
{
    int select = 0;
    for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
    {
        GridViewRow row = GridView1.Rows[i];
        CheckBox Chbox = (CheckBox)row.FindControl("CheckBox1");
        if (Chbox.Checked == true)
        {
            select++;
        }
    }

    if (select == 0)
    {
        ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please Select Record to Delete');", true);
    }

    for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
    {
        GridViewRow row = GridView1.Rows[i];
        Label lblAdNo = row.FindControl("lbl_AdNo") as Label;
        string AdNo = lblAdNo.Text;
        if (!string.IsNullOrEmpty(AdNo))
        {
            CheckBox Chbox = (CheckBox)row.FindControl("CheckBox1");
            if (Chbox.Checked)
            {
                con = new SqlDbConnect();
                con.SqlQuery("delete from tblSetMarks where AdmissionNo=@AdNo");
                con.Cmd.Parameters.AddWithValue("@AdNo", AdNo);
                con.NonQueryEx();
                //GridView1.Visible = false;            
            }
        }
    }
    ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Student's Marks Deteleted Successfully');", true);
    this.BindSectionGrid();
}

smile

0 2

Reply
User: smile
Replied: on Oct 31, 2017 02:15 AM
Report

How to add confirm delete message before deleting the record in this code?

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Oct 31, 2017 02:47 AM
Report

Hi smile,

Refer below article.

itsjaysh...

0 5

Reply
ANSWER
User: itsjayshah
Replied: on Oct 31, 2017 03:09 AM
Report

   <script type="text/javascript">
         function ConfirmDelete() {
             return confirm("Do you really want to delete?");
         }
    </script>

CommandName="remove" OnClientClick="return ConfirmDelete();" 
runat="server" ToolTip="Delete Details"></asp:LinkButton>

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Delete multiple rows in GridView with CheckBox selection and with confirmation using C# and VB.Net in ASP.Net

Delete multiple rows in GridView with CheckBox selection and with confirmation in ASP.Net

Company

Explore

Follow us

Contact Us