How to create HyperLinkField in datagridview where DataNavigateUrlFields and DataNavigateUrlFormat...

Question

Satyapriya Nayak · Answer

test3.aspx Untitled Page test3.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Display_related_records_gridview { public partial class test3 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { bindgrid(); } } private void bindgrid() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = select * from employee; com = new SqlCommand(str con); SqlDataReader reader; reader = com.ExecuteReader(); g1.DataSource = reader; g1.DataBind(); con.Close(); } } } test4.aspx Untitled Page Empname:   Empaddress:   Empsal:   Empphone:   Empfax:   Empcity:   Empstate:   Empzip:   Emplic:   Empstatus:   test4.aspx.cs using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Display_related_records_gridview { public partial class test4 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; string s1; SqlCommand com; protected void Page_Load(object sender EventArgs e) { try { SqlConnection con = new SqlConnection(strConnString); con.Open(); s1 = Request.QueryString[0]; str = select * from employee where empid=' + s1 + '; com = new SqlCommand(str con); SqlDataReader reader; reader = com.ExecuteReader(); if (reader.Read()) { Label1.Text = reader[empname].ToString(); Label2.Text = reader[empaddress].ToString(); Label3.Text = reader[empsal].ToString(); Label4.Text = reader[empphone].ToString(); Label5.Text = reader[empfax].ToString(); Label6.Text = reader[empcity].ToString(); Label7.Text = reader[empstate].ToString(); Label8.Text = reader[empzip].ToString(); Label9.Text = reader[emplic].ToString(); Label10.Text = reader[empstatus].ToString(); } } catch (Exception ex) { Response.Write(ex.Message); } } } }