ltdiv class34colsm634gt ltaspTextBox ID34txtSearch34 runat34server34 class34formcontrol34 BorderColor34green34 AutoPostBack34true34 ontextchanged34txtSearchTextChanged34 gt ltdivgtltaspGridView ID34GridView134 runat34server34 HeaderStyleBackColor343AC0F234 HeaderStyleForeColor34White34 CssClass34table tablestriped tablebor

Hi smileCheck this example Now please take its reference and correct your codeHTMLltaspGridView ID34GridView134 runat34server34 HeaderStyleBackColor343AC0F234 HeaderStyleForeColor34White34 CssClass34table tablestriped tablebordered tablehover34 OnRowDeleting34GridView1RowDeleting34 AutoGenerateColumns34false34 Width3410034gt ltColumnsgt ltaspTemplateField HeaderText34Product Code34 ItemStyleWidth3415034gt ltItemTemplategt ltaspLabel ID34lblCode34 runat34server34 Text39lt Eval34ItemCode34 gt39gtltaspLabelgt ltItemTemplategt ltaspTemplateFieldgt ltaspBoundField DataField34ItemName34 HeaderText34Product Name34 ItemStyleWidth34200px34 gt ltaspBoundField DataField34Rate34 HeaderText34Price34 ItemStyleCssClass34pr

Delete row from ASP.Net GridView on Button click using C# and VB.Net

smile

SOLVED CLOSED ACTIVE ANSWERED
User: smile
Posted: on Apr 23, 2018 11:51 PM
Forum: Data Controls
Answer: 1
Views: 26838
Sample Code: Download

<div class="col-sm-6">   
                    <asp:TextBox ID="txtSearch" runat="server" class="form-control" BorderColor="green" 
                           AutoPostBack="true" ontextchanged="txtSearch_TextChanged" />
                    </div>
<asp:GridView ID="GridView1" runat="server" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White" CssClass="table table-striped table-bordered table-hover"
        OnRowDeleting="OnRowDeleting" AutoGenerateColumns = "false" OnRowDataBound = "OnRowDataBound" Width="100%">
        <Columns>
            
            <asp:TemplateField HeaderText="Product Code" ItemStyle-Width="150">
                <ItemTemplate>
                    <asp:Label ID="lblCode" runat="server" Text='<%# Eval("ItemCode") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>            
            
            <asp:BoundField DataField="ItemName" HeaderText="Product Name" ItemStyle-Width="200px" />            
            <asp:BoundField DataField="Rate" HeaderText="Price" ItemStyle-CssClass="price" ItemStyle-Width="100px" />
                
                                
                <asp:TemplateField HeaderText="Quantity" ItemStyle-Width="200px">
                    <ItemTemplate>
                        <asp:TextBox ID="txtQuantity" runat="server" class="form-control" Width="100"></asp:TextBox>
                        <asp:HiddenField ID="hdnfldQty" runat="server"  /> 
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Total" ItemStyle-Width="200px">
                    <ItemTemplate>
                       <asp:Label ID="lblTotal" runat="server" Text="0"></asp:Label>                       
                    </ItemTemplate>
                </asp:TemplateField>

                <asp:CommandField ShowDeleteButton="True" ButtonType="Button" />
            
        </Columns>
    </asp:GridView>

my code and output is attached

    protected void txtSearch_TextChanged(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(txtSearch.Text.Trim()))
        {
            if (ViewState["tblStores"] == null)
            {
                DataTable dt = GetProduct(txtSearch.Text.Trim());
                ViewState["tblStores"] = dt;
            }
            else
            {
                DataTable previousProducts = ViewState["tblStores"] as DataTable;
                DataTable currentProducts = GetProduct(txtSearch.Text.Trim());
                currentProducts.Merge(previousProducts);
                currentProducts.DefaultView.Sort = "ItemCode";
                ViewState["tblStores"] = currentProducts;
            }

            // Get distinct record if you click multiple time for same item it will filter with distinct record.
            DataTable distinctProduct = ViewState["tblStores"] as DataTable;
            GridView1.DataSource = distinctProduct.DefaultView.ToTable(true);
            GridView1.DataBind();
        }
        txtSearch.Text = string.Empty;
        txtSearch.Focus();
    }
    protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string item = e.Row.Cells[0].Text;
            foreach (Button button in e.Row.Cells[5].Controls.OfType<Button>())
            {
                if (button.CommandName == "Delete")
                {
                    button.Attributes["onclick"] = "if(!confirm('Do you want to delete " + item + "?')){ return false; };";
                }
            }
        }
    }
    protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int index = Convert.ToInt32(e.RowIndex);
        DataTable dt = ViewState["tblStores"] as DataTable;
        dt.Rows[index].Delete();
        ViewState["tblStores"] = dt; 
    }

pandeyis...

0 4

Reply
ANSWER
User: pandeyism
Replied: on Apr 24, 2018 01:34 AM
Report

Hi smile,

Check this example. Now please take its reference and correct your code.

HTML

<asp:GridView ID="GridView1" runat="server" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
    CssClass="table table-striped table-bordered table-hover" OnRowDeleting="GridView1_RowDeleting"
    AutoGenerateColumns="false" Width="100%">
    <Columns>
        <asp:TemplateField HeaderText="Product Code" ItemStyle-Width="150">
            <ItemTemplate>
                <asp:Label ID="lblCode" runat="server" Text='<%# Eval("ItemCode") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="ItemName" HeaderText="Product Name" ItemStyle-Width="200px" />
        <asp:BoundField DataField="Rate" HeaderText="Price" ItemStyle-CssClass="price" ItemStyle-Width="100px" />
        <asp:TemplateField HeaderText="Quantity" ItemStyle-Width="200px">
            <ItemTemplate>
                <asp:TextBox ID="txtQuantity" runat="server"></asp:TextBox>
                <asp:HiddenField ID="hdnfldQty" runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Total" ItemStyle-Width="200px">
            <ItemTemplate>
                <asp:Label ID="lblTotal" runat="server" Text="0"></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:CommandField ShowDeleteButton="True" ButtonType="Button" />
    </Columns>
</asp:GridView>

Namespaces

using System.Data;

VB.Net

Imports System.Data

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[5] { new DataColumn("ItemCode", typeof(int)),
                        new DataColumn("ItemName", typeof(string)),
                        new DataColumn("Rate", typeof(string)),
                        new DataColumn("Quantity", typeof(string)),
                        new DataColumn("Total",typeof(string)) });
        dt.Rows.Add(1, "John Hammond", "United States");
        dt.Rows.Add(2, "Mudassar Khan", "India");
        dt.Rows.Add(3, "Suzanne Mathews", "France");
        dt.Rows.Add(4, "Robert Schidner", "Russia");
        ViewState["Data"] = dt;
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    int index = Convert.ToInt32(e.RowIndex);
    DataTable dt = (DataTable)ViewState["Data"];
    dt.Rows[index].Delete();
    ViewState["Data"] = dt;
    GridView1.DataSource = dt;
    GridView1.DataBind();

}

Vb.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.AddRange(New DataColumn(4) {New DataColumn("ItemCode", GetType(Integer)), New DataColumn("ItemName", GetType(String)), New DataColumn("Rate", GetType(String)), New DataColumn("Quantity", GetType(String)), New DataColumn("Total", GetType(String))})
        dt.Rows.Add(1, "John Hammond", "United States")
        dt.Rows.Add(2, "Mudassar Khan", "India")
        dt.Rows.Add(3, "Suzanne Mathews", "France")
        dt.Rows.Add(4, "Robert Schidner", "Russia")
        ViewState("Data") = dt
        GridView1.DataSource = dt
        GridView1.DataBind()
    End If
End Sub

Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As GridViewDeleteEventArgs)
    Dim index As Integer = Convert.ToInt32(e.RowIndex)
    Dim dt As DataTable = CType(ViewState("Data"), DataTable)
    dt.Rows(index).Delete()
    ViewState("Data") = dt
    GridView1.DataSource = dt
    GridView1.DataBind()
End Sub

Screenshot

Delete row from ASP.Net GridView on Button click using C# and VB.Net

Company

Explore

Follow us

Contact Us