[thelist] ASP.NET: Specified cast is not valid.

Casey Crookston caseyc at netgainhosting.com
Mon May 15 16:58:23 CDT 2006


When trying to use roles authentication, I receive this error in the
global.asax file:

 

Exception Details: System.InvalidCastException: Specified cast is not
valid.

Source Error: 

 
Line 57:             Dim arrRoles As String()
Line 58:             conWiese.Open()
Line 59:             arrRoles = cmdSelect.ExecuteScalar()
Line 60:             conWiese.Close()
Line 61: 


Source File: C:\Sites\local.wieseford.com\Global.asax.vb    Line: 59

 

Line 59 is: arrRoles = cmdSelect.ExecuteScalar()

 

Any idea?  Thanks!

 

 

    Sub Application_AuthenticateRequest(ByVal sender As Object, ByVal e
As System.EventArgs)

        If Context.Request.IsAuthenticated() Then

            ' extract the user ID from HttpApplication

            Dim userID As String = Context.User.Identity.Name

 

            ' query the user role from the dastabase bases on user ID

            Dim conWiese As New
SqlConnection(ConfigurationSettings.AppSettings("jwf"))

            Dim cmdSelect As New SqlCommand("SELECT role FROM Employees
WHERE UserName = @userName", conWiese)

            cmdSelect.Parameters.Add(New SqlParameter("@userName",
SqlDbType.NVarChar, 500))

            cmdSelect.Parameters.Item("@userName").Value = userID

            Dim arrRoles As String()

            conWiese.Open()

            arrRoles = cmdSelect.ExecuteScalar()

            conWiese.Close()

 

            ' assign the user a role based on the query

            Context.User = New GenericPrincipal(Context.User.Identity,
arrRoles)

        End If

    End Sub




More information about the thelist mailing list