Delete Multiple Rows from Gridview

The code below is to delete multiple rows form gridview at once. In this example DataTable is used to bind GridView.
-----------------------------------------------------------------------------------------------------------------------------------
ASPX Page Code
-----------------------------------------------------------------------------------------------------------------------------------


<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            width: 50%;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>


    <span style="width:50%; margin:0 auto; display:block; color:Green; font-family:Arial; font-size:13px; letter-spacing:1px; line-height:1.7em; padding-top:20px; padding-bottom:30px;">


    Example to delete meultiple rows from gridview at once. First add values in text box and click add.
    Add as many values as you want. Check the checkboxes for rows you want to delete and click Delete.
    In this example DataTable is used to bing GridView.


    </span>
    
        <table align="center" class="style1">
            <tr>
                <td style="text-align: right">
                    Name</td>
                <td>
                    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td style="text-align: right">
                    Age</td>
                <td>
                    <asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
                <td>
                    <asp:Button ID="btnAdd" runat="server" Text="Add" Width="100px" 
                        onclick="btnAdd_Click" />
                </td>
            </tr>
        </table>
    <br />
    <center>
        <asp:GridView ID="gridAdd" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" ForeColor="#333333" GridLines="None">
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <Columns>
                <asp:TemplateField HeaderText="Delete">
                    <ItemTemplate>
                        <asp:CheckBox ID="chkDelete" runat="server" />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Name">
                    <ItemTemplate>
                        <asp:TextBox ID="txtName" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Age">
                    <ItemTemplate>
                        <asp:TextBox ID="txtAge" runat="server" Text='<%# Bind("Age") %>'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <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>
        <br />
        <asp:Button ID="btnDelete" runat="server" onclick="btnDelete_Click" 
            Text="Delete" Width="100px" />
        </center>
    </div>
    </form>
</body>
</html>

-----------------------------------------------------------------------------------------------------------------------------------
CS Page Code
-----------------------------------------------------------------------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class _Default : System.Web.UI.Page 
{
    static DataTable dtGrid; // Declare Static Datatable
   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DummyDataTable();
            btnDelete.Visible = false;
        }
    }

    #region Dummy DataTable 

    public void DummyDataTable() // Add columns in datatable to create layout of table
    {
        dtGrid = new DataTable("Details");

        DataColumn dcName = new DataColumn("Name");
        DataColumn dcAge = new DataColumn("Age");
        DataColumn check = new DataColumn("Check"); // this column holds the value of checkbox

        dtGrid.Columns.Add(dcName);
        dtGrid.Columns.Add(dcAge);
        dtGrid.Columns.Add(check);
        
        gridAdd.DataSource = dtGrid;
        gridAdd.DataBind();
        
    }

    #endregion

    #region Add Values to Gridview

    protected void btnAdd_Click(object sender, EventArgs e) // Adding values to datatable 
    {
        DataRow drGrid = dtGrid.NewRow();   

        drGrid["Name"] = txtName.Text;
        drGrid["Age"] = txtAge.Text;
        drGrid["Check"] = "0";      // setting 0 as default for each row

        dtGrid.Rows.Add(drGrid);

        gridAdd.DataSource = dtGrid;
        gridAdd.DataBind();

        btnDelete.Visible = true;
    }

    #endregion

    #region Delete Multipple Rows From Grid View

    protected void btnDelete_Click(object sender, EventArgs e)
    {
        int chk = 0;
        for (int i = 0; i < gridAdd.Rows.Count; i++)
        {
            if (((CheckBox)(gridAdd.Rows[i].FindControl("chkDelete"))).Checked)
            {
                dtGrid.Rows[i]["Check"] = "1";      // if checkbox is checked then set value to 1
                chk = 1;
            }
        }

        if (chk > 0)
        {

            for (int j = 0; j < dtGrid.Rows.Count; j++)
            {
                if (dtGrid.Rows[j]["Check"] == "1")
                {
                    dtGrid.Rows[j].Delete();    // Delete those rows form datatable where Check value = 1
                    j = -1;
                }
            }

            gridAdd.DataSource = dtGrid;    // Bind gridview to datatable
            gridAdd.DataBind();

            if (dtGrid.Rows.Count > 0)
            {
                btnDelete.Visible = true;
            }
            else
            {
                btnDelete.Visible = false;
            }
        }
        else
        {
            Response.Write("<script language='javascript'>alert('No row checked.\\r\\nPlease check row to delete form gridview.');</script>");
        }
    } 

    #endregion

}

Download complete code from the link

http://www.navvtech.com/demo/dotnet/GridViewMultiDelete.rar

Comments

Post a Comment

Popular posts from this blog

Change Css Class of li in ul onclick

Image
Below is the simple and a short code to change or set the background color of item in menu onclick or active tab of menu (i.e. li of ul) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>List Item</title> <style type="text/css"> ul {     list-style-type:none;     float:left;     border-bottom: solid 2px Red;     padding-right:40px; } ul li {     float:left;     width:auto;     padding:8px;     display:block;     cursor:pointer; } </style> <script type="text/javascript" language="javascript">     function checklist(ctrl)     {   ...
Read more

Find missing sequence number. Get the numbers where sequence is missing.

Most of the time the question was asked while having Database interview that we have number sequence present in a table but some numbers are missing. Can you write the query to detect where number is missing from sequence and if possible then also can get the missing number? OK, it’s not a rocket science so let’s begin. Please give me a paper and a pen to write query Sir. I am using a Temporary variable table here. DECLARE @Temp TABLE (        Id INT IDENTITY ( 1 , 1 ),        Num INT ) INSERT INTO @Temp ( Num ) VALUES ( 1 ) ,( 2 ), ( 4 ), ( 6 ), ( 7 ), ( 9 ) SELECT * FROM @Temp SELECT a . Id , a . Num , b . Num , ( a . Num - b . Num ) as Diff , ( b . Num + 1 ) as MissingNum FROM @Temp a LEFT JOIN @Temp b ON b . Id = ( a . Id - 1 ) WHERE ( a . Num - b . Num ) > 1 You see it’s just a simple SELECT statement but tricky. OK, yes it will produce m...
Read more

Get Query String Values With Javascript

Image
JavaScript Code To  Retrieve Query String Values This topic shows you how you can retrieve the query string values from a URL using JavaScript. The code is simple and understandable. Below is the complete code. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Query String using Javascript</title> <script type="text/javascript" language="javascript">     function getquerystring()     {         var qsarr = new Array();                  var qs = location.search.substring(1);         var singleqs = new Array();         var str ="";         qsarr = qs.split('&');    ...
Read more