Using asp:HyperLinkColumn Pass DB Value

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hi 

I am pretty new to asp.net and have started building my first app.  OK so I have a dataset which I populate as below.  I then put the results in a datagrid.  I then want to use a an asp:HyperLinkColumn which shows SvcDesc but has a value of SvcID.  When the user click this link the selected rows SvcID is sent to another page via a querystring.  However im unsure how to include the SvcID into the DataNavigateUrlFormatString.

I had a an attempt by doing something like but didnt work

DataNavigateUrlFormatString="details.aspx?SvcID=<%#SvcID%>"

But did not work 

Dim Conn As New SqlConnection(ConfigurationSettings.AppSettings("connBSS"))
Conn.Open()
Dim strSQL As String = "SELECT SvcDesc, SvcID, FROM ServiceProviderServices"
Dim objAdapter As New SqlDataAdapter(strSQL, Conn)
objAdapter.Fill(dsResults, "Results")
Dim objDataView As New DataView(dsResults.Tables("Results"))
dgResults.DataSource = dsResults
dgResults.DataBind()

Many thanks in advance