Form hyperlink with querystring inside gridview in ASP.Net/C#.Net

Introduction:

In this article I am going to explain forming the hyperlink inside a gridview with the querystring.

Description:

In the previous article I have explained about how to pass the query string of a page to a hyperlink as a querystring. In this article I am explaining the way of forming hyperlink inside gridview. In the below code there is a gridview with id grdgridview. Inside the gridview I have the hyperlink with two querystring values id and name. The navigate url string is given in the attribute DataNavigateUrlFormatString. The value for the query string is specified in the attribute  DataNavigateUrlFields.

The Asp.Net code is given below.

<%@ 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>

</head>

<body>

    <form id="form1" runat="server">

    <div>

        <asp:GridView ID="grdview" runat="server">

            <Columns>

                <asp:HyperLinkField DataNavigateUrlFields="empid, empname" DataNavigateUrlFormatString="~/empprofile.aspx?id={0}&name={1}"

                    Target="_blank" Text="Edit" HeaderText="Edit" />

            </Columns>

        </asp:GridView>

    </div>

    </form>

</body>

</html>

In the code behind add the below code to bind the dataset.

protected void Page_Load(object sender, EventArgs e)

{

    DataSet ds = new DataSet();

    DataTable dt;

    SqlConnection con = new SqlConnection("myconnectionstring");

    SqlCommand cmd = new SqlCommand();

    cmd.CommandText = "MyProcedure";

    cmd.CommandType = CommandType.StoredProcedure;

    cmd.Connection = con;

    SqlDataAdapter sda = new SqlDataAdapter(cmd);

    sda.Fill(ds);

    grdview.DataSource = ds.Tables[0];

    grdview.DataBind();

}

Do you like this code. Then comment here or share with your friends. Or like our facebook page.