Hi. Stuck with some problem again. Here is the case. I have a sql server database table for storing users information. In the table there's a field called menu_link which stores menu URLs for my web application. This is to restrict which menus are viewable to authorized users. Those who are not are unable to see these menus on the home page. so in the page load of the home page i have this:
Dim menuLink() As String
mstrSql = "Select taskID, menu_link from EClinicUser where roleID like 'N & %' "
Try
If gmyConn.State = ConnectionState.Closed Then
gmyConn.Open()
End If
mda = New SqlDataAdapter(mstrSql, "Links")
mds = New DataSet
mda.Fill(mds, "Links")
Catch ex As Exception
lblAlert.Text = ex.Message
End Try
I'm supposed to store the data set results into the menuLink array. Then from this result, I need to code my HTML so that the links could be arranged in table form. As in <table><tr><td></td></tr></table>. I need to place the result menu links within the <td> tags. I really have no idea how to do this. Please help. Thanks alot.