Bind GridView from Database and add new row on Button Click using C# and VB.Net in ASP.Net

akhter

SOLVED CLOSED ACTIVE ANSWERED
User: akhter
Posted: on Jun 04, 2020 07:30 AM
Forum: Data Controls
Answer: 1
Views: 3959

How to add row into gridview after retrieving data into gridview.

when i adding row into gridview then gridview data get refresh after that new row getting inserted but removing retrieving data from gridview ?

i am retrieving data into gridview

SqlCommand cmdbno = new SqlCommand("[Sp_Retrieve_Detail_UD]", con);
cmdbno.CommandType = CommandType.StoredProcedure;
cmdbno.Parameters.AddWithValue("@ID", txtimpno.Text);
SqlDataAdapter adptbno = new SqlDataAdapter(cmdbno);
DataTable dtbno = new DataTable();
adptbno.Fill(dtbno);
GridView1.DataSource = dtbno;
GridView1.DataBind();
cmdbno.Dispose();
con.Close();

html of gridview

<asp:GridView ID="GridView1" runat="server" AllowSorting="True" HorizontalAlign="Center"
    AutoGenerateColumns="false" CssClass="mygrdContent" HeaderStyle-BackColor="#66ccff"
    HeaderStyle-CssClass="header" HeaderStyle-ForeColor="White" OnRowDataBound="GridView1_RowDataBound"
    OnRowDeleting="GridView1_RowDeleting" PagerStyle-CssClass="pager" RowStyle-CssClass="rows"
    Width="452px" ShowFooter="True">
    <Columns>
        <asp:TemplateField HeaderText="Container">
            <ItemTemplate>
                <asp:Label ID="Contnam" runat="server" Text='<%#Bind("Contnam")%>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="QTY">
            <ItemTemplate>
                <asp:Label ID="QTY" runat="server" Text='<%#Bind("QTY")%>'></asp:Label>
            </ItemTemplate>
            <FooterTemplate>
                <asp:Label ID="lblTotal1" runat="server"></asp:Label>
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
            </ItemTemplate>
            <EditItemTemplate>
            </EditItemTemplate>
        </asp:TemplateField>
        <asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
    </Columns>
    <HeaderStyle BackColor="#66CCFF" ForeColor="White" />
    <SelectedRowStyle BackColor="Yellow" />
</asp:GridView>

code for adding row into gridview

if (ddlcontainer.SelectedItem != null)
{
    // get value and text which item you have selected
    int CN_ID = Convert.ToInt32(ddlcontainer.SelectedItem.Value.ToString());
    string Contnam = ddlcontainer.SelectedItem.Text.ToString();


    //add the selected item to gridview

    DataTable dtgridview = ViewState["dt"] as DataTable;
    DataRow dr2 = dtgridview.NewRow();
    bool ifExist = false;

    if (!ifExist)
    {

        dr2["CN_ID"] = CN_ID;
        dr2["Contnam"] = Contnam;


        dr2["QTY"] = txtqty.Text;
        dtgridview.Rows.Add(dr2);
        // dtgridview.Rows.Add(dr2);
        ViewState["dt"] = dtgridview;
        GridView1.DataSource = dtgridview;
        GridView1.DataBind();
    }
    else
    {
        // this.lbgvck.Visible = true;
        //  lbgv.Text = "Bale Already Added...";
    }
}

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

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Jun 04, 2020 08:43 AM
Report

Hi akhter,

Check below sample.

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="CustomerId" HeaderText="Id" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:BoundField DataField="Country" HeaderText="Country" />
    </Columns>
</asp:GridView>
<hr />
ID:<asp:TextBox runat="server" ID="txtID" />
<br />
Name:<asp:TextBox runat="server" ID="txtName" />
<br />
Country:<asp:TextBox runat="server" ID="txtCountry" />
<br />
<asp:Button ID="btnAdd" runat="server" Text="Add" OnClick="OnAdd" />

Namespaces

using System.Configuration;
using System.Data;
using System.Data.SqlClient;

VB.Net

Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        PopulateData();
        BindGridView();
    }
}
protected void OnAdd(object sender, EventArgs e)
{
    DataTable dtgridview = ViewState["Data"] as DataTable;
    DataRow dr2 = dtgridview.NewRow();
    dr2["CustomerId"] = txtID.Text;
    dr2["Name"] = txtName.Text;
    dr2["Country"] = txtCountry.Text;
    dtgridview.Rows.Add(dr2);
    ViewState["Data"] = dtgridview;
    BindGridView();
}
private void BindGridView()
{
    GridView1.DataSource = ViewState["Data"] as DataTable;
    GridView1.DataBind();
}
private void PopulateData()
{
    string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        string query = "SELECT * FROM Customers";
        using (SqlCommand cmd = new SqlCommand(query))
        {
            cmd.Connection = con;
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            ViewState["Data"] = dt;
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        PopulateData()
        BindGridView()
    End If
End Sub
Protected Sub OnAdd(ByVal sender As Object, ByVal e As EventArgs)
    Dim dtgridview As DataTable = TryCast(ViewState("Data"), DataTable)
    Dim dr2 As DataRow = dtgridview.NewRow()
    dr2("CustomerId") = txtID.Text
    dr2("Name") = txtName.Text
    dr2("Country") = txtCountry.Text
    dtgridview.Rows.Add(dr2)
    ViewState("Data") = dtgridview
    BindGridView()
End Sub
Private Sub BindGridView()
    GridView1.DataSource = TryCast(ViewState("Data"), DataTable)
    GridView1.DataBind()
End Sub
Private Sub PopulateData()
    Dim constr As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Dim query As String = "SELECT * FROM Customers"
        Using cmd As SqlCommand = New SqlCommand(query)
            cmd.Connection = con
            Dim sda As SqlDataAdapter = New SqlDataAdapter(cmd)
            Dim dt As DataTable = New DataTable()
            sda.Fill(dt)
            ViewState("Data") = dt
        End Using
    End Using
End Sub

Screenshot

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

Bind GridView from Database and add new row on Button Click using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us