Pass (Send) query string using GridView HyperLinkField Click using C# and VB.Net in ASP.Net

Hi Prathyusha,

Please check the below sample and modify your code accordingly.

HTML

Default

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:HyperLinkField DataTextField="Name" DataNavigateUrlFields="Id" DataNavigateUrlFormatString="~/Details.aspx?Id={0}"
            HeaderText="Name" />
        <asp:BoundField DataField="Country" HeaderText="Country" />
    </Columns>
</asp:GridView>

Details

Name: <asp:TextBox runat="server" ID="txtName" />
<br /><br />
Country: <asp:TextBox runat="server" ID="txtCountry" />

Code

C#

Default

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        System.Data.DataTable dt = new System.Data.DataTable();
        dt.Columns.AddRange(new System.Data.DataColumn[3] {
            new System.Data.DataColumn("Id"),
            new System.Data.DataColumn("Name"),
            new System.Data.DataColumn("Country") });
        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");
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

Details

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string id = HttpUtility.UrlDecode(Request.QueryString["Id"]);
        System.Data.OleDb.OleDbConnection connn = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Tamanna\Desktop\Employee.accdb");
        connn.Open();
        string query = "SELECT Id,Name,Country FROM Customers WHERE Id = " + id;
        System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, connn);
        System.Data.OleDb.OleDbDataReader rd = cmd.ExecuteReader();
        if (rd.Read())
        {
            txtName.Text = rd.GetValue(1).ToString();
            txtCountry.Text = rd.GetValue(2).ToString();
        }
        connn.Close();
    }
}

VB.Net

Default

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As System.Data.DataTable = New System.Data.DataTable()
        dt.Columns.AddRange(New System.Data.DataColumn(2) {New System.Data.DataColumn("Id"), New System.Data.DataColumn("Name"), New System.Data.DataColumn("Country")})
        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")
        GridView1.DataSource = dt
        GridView1.DataBind()
    End If
End Sub

Details

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim id As String = HttpUtility.UrlDecode(Request.QueryString("Id"))
        Dim connn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Tamanna\Desktop\Employee.accdb")
        connn.Open()
        Dim query As String = "SELECT Id,Name,Country FROM Customers WHERE Id = " & id
        Dim cmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand(query, connn)
        Dim rd As System.Data.OleDb.OleDbDataReader = cmd.ExecuteReader()
        If rd.Read() Then
            txtName.Text = rd.GetValue(1).ToString()
            txtCountry.Text = rd.GetValue(2).ToString()
        End If
        connn.Close()
    End If
End Sub

Screenshots

Access Database

Output