Hi,
I want to populate some data from Access database in a table, but I don't know how to make the table cell content clickable. See my code below:
Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\website\forms\App_Data\forms.mdb;Persist Security Info=False"
Dim cn As New OleDbConnection(strConnection)
cn.Open()
Dim strSQL As String = "select * from form "
Dim cm As New OleDbCommand(strSQL, cn)
Dim dr As OleDbDataReader = cm.ExecuteReader(CommandBehavior.CloseConnection)
While dr.Read
Dim trRow As New HtmlTableRow
Dim tdData As New HtmlTableCell
tdData.InnerHtml = dr("form_number").ToString
trRow.Cells.Add(tdData)
tdData = New HtmlTableCell
tdData.InnerHtml = dr("form_name").ToString
trRow.Cells.Add(tdData)
tbloutput.rows.add(trRow)
End While
How do I make the form_number field as a hyperlink? Or should I use other controls? Thank you for your help in advance!
