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.
You should provide output of this code. So we dont need to execute this.
ReplyDelete