ASP.NET

ASP.NET RSS

Passing values from server-side code to html

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2006

Posts: 7

Reputation: danae is an unknown quantity at this point

Solved Threads: 0

danae

Offline

Newbie Poster

Passing values from server-side code to html

Oct 24th, 2006

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:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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
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.