Insert records from Database to GridView on Button Click using C# and VB.Net in ASP.Net

Hi akhter,

Check this example now and take its reference.

HTML

Add ID :<asp:TextBox runat="server" ID="txtID" /><br />
<br />
<asp:Button ID="btnAdd" Text="Add" runat="server" OnClick="Add_OnClick" /><br />
<br />
<asp:GridView runat="server" ID="gvOrderDetails" AutoGenerateColumns="false" EmptyDataText="No Record Found.">
    <Columns>
        <asp:BoundField DataField="OID" HeaderText="Order ID" />
        <asp:BoundField DataField="BID" HeaderText="B ID" />
        <asp:BoundField DataField="CodeItem" HeaderText="Code Item" />
        <asp:BoundField DataField="QTY" HeaderText="Quantity" />
    </Columns>
</asp:GridView>

Namespaces

C#

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

VB.Net

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

Code

C#

protected void Add_OnClick(object sender, EventArgs e)
{
    DataTable dt;
    if (ViewState["dtOrder"] == null)
    {
        dt = GetData(this.txtID.Text.Trim());

        if (dt.Rows.Count > 0)
        {
            ViewState["dtOrder"] = dt;
        }
        else
        {
            ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('" + "No Record Found With ID : " + txtID.Text.Trim() + "')", true);
        }
    }
    else
    {
        dt = ViewState["dtOrder"] as DataTable;
        DataTable dt1 = GetData(this.txtID.Text.Trim());
        if (dt1.Rows.Count > 0)
        {
            dt.Merge(dt1);
            ViewState["dtOrder"] = dt;
        }
        else
        {
            ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('" + "No Record Found With ID : " + txtID.Text.Trim() + "')", true);
        }
    }
    BindOrder(dt);
    this.txtID.Text = string.Empty;
}

private DataTable GetData(string id)
{
    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT M.OID,D.BID,D.CodeItem,D.QTY FROM PackMaster M INNER JOIN PackDetail D ON M.OID = D.ODI WHERE M.OID=@OID", con))
        {
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("@OID", id);
            using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
            {
                DataTable dt = new DataTable();
                adapter.Fill(dt);
                return dt;
            }
        }
    }
}

private void BindOrder(DataTable dt)
{
    this.gvOrderDetails.DataSource = ViewState["dtOrder"] as DataTable;
    this.gvOrderDetails.DataBind();
}

VB.Net

Protected Sub Add_OnClick(ByVal sender As Object, ByVal e As EventArgs)
    Dim dt As DataTable
    If ViewState("dtOrder") Is Nothing Then
        dt = GetData(Me.txtID.Text.Trim())
        If dt.Rows.Count > 0 Then
            ViewState("dtOrder") = dt
        Else
            ClientScript.RegisterClientScriptBlock(Me.GetType(), "", "alert('" & "No Record Found With ID : " & txtID.Text.Trim() & "')", True)
        End If
    Else
        dt = TryCast(ViewState("dtOrder"), DataTable)
        Dim dt1 As DataTable = GetData(Me.txtID.Text.Trim())
        If dt1.Rows.Count > 0 Then
            dt.Merge(dt1)
            ViewState("dtOrder") = dt
        Else
            ClientScript.RegisterClientScriptBlock(Me.GetType(), "", "alert('" & "No Record Found With ID : " & txtID.Text.Trim() & "')", True)
        End If
    End If

    BindOrder(dt)
    Me.txtID.Text = String.Empty
End Sub

Private Function GetData(ByVal id As String) As DataTable
    Using con As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("conString").ConnectionString)
        Using cmd As SqlCommand = New SqlCommand("SELECT M.OID,D.BID,D.CodeItem,D.QTY FROM PackMaster M INNER JOIN PackDetail D ON M.OID = D.ODI WHERE M.OID=@OID", con)
            cmd.CommandType = CommandType.Text
            cmd.Parameters.AddWithValue("@OID", id)
            Using adapter As SqlDataAdapter = New SqlDataAdapter(cmd)
                Dim dt As DataTable = New DataTable()
                adapter.Fill(dt)
                Return dt
            End Using
        End Using
    End Using
End Function

Private Sub BindOrder(ByVal dt As DataTable)
    Me.gvOrderDetails.DataSource = TryCast(ViewState("dtOrder"), DataTable)
    Me.gvOrderDetails.DataBind()
End Sub

Screenshot