Can someone please tell me why I keep being redirected back to the login page
even though I have logged in with the correct cridentials!!!
I have used this code before on another site and it works fine but when I
copied it across to the new site it stops working! All the variables are
passed when I do a debug but it just returns me to the login page again and
again!
Please help! It's driving me nuts!
Thanks!!!
<<CODE>>>
If Page.IsValid Then
'Connect to Database for User Validation
If DBConnection(tx tUserName.Text, txtPassword.Tex t) Then
FormsAuthentica tion.RedirectFr omLoginPage(txt UserName.Text,
Remember.Checke d)
Else
' Credentials are Invalid
lblMessage.Text = "Invalid Login!"
End If
End If
End Sub
Function DBConnection(By Val txtUserName As String, ByVal txtPassword As
String) As Boolean
Dim Myconn As New
SqlConnection(C onfigurationSet tings.AppSettin gs("strConn"))
Dim cmd As New SqlCommand("Val idateUser", Myconn)
cmd.CommandType = CommandType.Sto redProcedure
Dim objParam1, objParam2 As SqlParameter
objParam1 = cmd.Parameters. Add("@UserName" , SqlDbType.Char)
objParam2 = cmd.Parameters. Add("@Password" , SqlDbType.Char)
objParam1.Direc tion = ParameterDirect ion.Input
objParam2.Direc tion = ParameterDirect ion.Input
objParam1.Value = txtUserName
objParam2.Value = txtPassword
Try
If Myconn.State = ConnectionState .Closed Then
Myconn.Open()
End If
Dim objReader As SqlDataReader
objReader = cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion)
While objReader.Read( )
If CStr(objReader. GetValue(0)) <> "1" Then
lblMessage.Text = "Invalid Login!"
Else
objReader.Close ()
Return True
End If
End While
Catch ex As Exception
lblMessage.Text = "Error Connecting to Database!"
End Try
End Function
<<<Web.Config>> >
<authenticati on mode="Forms">
<forms name="NWLogin" loginUrl="Admin/Login.aspx" />
</authentication>
<!-- AUTHORIZATION
This section sets the authorization policies of the application.
You can allow or deny access
to application resources by user or role. Wildcards: "*" mean
everyone, "?" means anonymous
(unauthenticate d) users.
-->
<authorizatio n>
<allow roles="Administ rator, User" /> <!-- ONLY USERS ALLOWED THAT BELONG
TO THESE GROUPS -->
<deny users="*" /> <!-- Deny all users -->
<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>
