Hi
I am trying to identify which group the user belongs to in the database and assign the group a hem page. The database has a column userid and groupid. Gels, my. Code can match the user to the user column. But, it does not know how to look for the group column.
Help!,,
Protected Sub ContentMethod()
Dim UserA As String = User.Identity.Name.Substring(User.Identity.Name.IndexOf("\") + 1)
If User.Identity.IsAuthenticated Then
Dim connectionString As String = ConfigurationManager.ConnectionStrings("mdmConnectionString").ToString()
Dim sql As String = "SELECT mdm.*, userid AS Expr1 FROM mdm WHERE userid = @userid"
Dim sqlDataTable = New DataTable()
Using sqlConnection As New SqlConnection(connectionString)
Using sqlDataAdapter As New SqlDataAdapter(sql, sqlConnection)
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@userid", UserA) ...
Go to the complete details ...