I have the code below and need to make the last field a hyperlink to VeiwQuoteID.aspx
Dim EMailLogDataStoredProcedur
e As String
Select Case Request.QueryString("sp")
Case "1"
EMailLogDataStoredProcedur
e = "usr_sel_EMailLog_BrokerAd
ministrati
onEMailLog
Output"
Case "2"
EMailLogDataStoredProcedur
e = "usr_sel_EMailLog_BrokerAd
ministrati
onEMailLog
Output_Bra
ndedPageOw
nerEMailOu
tput"
Case "3"
EMailLogDataStoredProcedur
e = "usr_sel_EMailLog_BrokerAd
ministrati
onEMailLog
Output_Man
agerEmploy
eeEMailOut
put"
End Select
Dim dt As New DataTable
'dt.Columns.Add("ID", GetType(Integer))
dt.Columns.Add("Sender", GetType(String))
dt.Columns.Add("Recipient"
, GetType(String))
dt.Columns.Add("Subject", GetType(String))
dt.Columns.Add("SentDate",
GetType(DateTime))
dt.Columns.Add("View", GetType(String))
'Dim Crypter As New Encryption64
Dim strBrokerEmail As String = Request.Cookies("BrokerEMa
ilAddress"
).Value
'MsgBox(strBrokerEmail, MsgBoxStyle.Information, "Broker Email")
Dim strSP As String = EMailLogDataStoredProcedur
e
Dim EMailLogDataConnString As String = ConfigurationManager.AppSe
ttings("**
*")
Dim EMailLogDataConn As New SqlConnection(EMailLogData
ConnString
)
Dim SQLEMailLogDataCmd As New SqlCommand(strSP, EMailLogDataConn)
Dim EMailLogData As SqlDataReader
SQLEMailLogDataCmd.Command
Type = CommandType.StoredProcedur
e
SQLEMailLogDataCmd.Paramet
ers.AddWit
hValue("@B
rokerEMail
Address", strBrokerEmail)
SQLEMailLogDataCmd.Paramet
ers.AddWit
hValue("@S
tartDate",
StartDate.Text)
SQLEMailLogDataCmd.Paramet
ers.AddWit
hValue("@E
ndDate", EndDate.Text)
EMailLogDataConn.Open()
EMailLogData = SQLEMailLogDataCmd.Execute
Reader
While EMailLogData.Read
dt.Rows.Add(New Object() {LCase(EMailLogData("Sende
r")), LCase(EMailLogData("Recipi
ent")), LCase(EMailLogData("Subjec
t")), LCase(EMailLogData("SentDa
te")), LCase(EMailLogData("QuoteI
D"))})
End While
If EMailLogData.HasRows = False Then
lblNoResults.Visible = False
lblNoResults.Text = "**Sorry there were no results for your query"
lblNoResults.Visible = True
End If
If EMailLogData.HasRows = True Then
lblNoResults.Visible = False
Grid1.DataSource = dt
Grid1.DataBind()
Grid1.Visible = True
End If
SQLEMailLogDataCmd.Dispose
()
SQLEMailLogDataCmd = Nothing
EMailLogData.Close()
EMailLogData = Nothing
EMailLogDataConn.Close()
EMailLogDataConn.Dispose()
EMailLogDataConn = Nothing
EMailLogDataConnString = Nothing