Login control not working

Question

Hi, Login control authenticates only one user... Whats wrong?

Suthish Nair · Answer

Are these lines of code copied from some source, or you only coded it. Put a breakpoint and check each line, what happening. 1. Why you fetching all users from DB. ""select username,password from user_login" 2. Why dont the select statement like this "select username,password from user_login where username = username" I dont know the table structure, built the query according to that.

Sam Hobbs · Answer

Thank you, Ananya; that helps. I probably cannot help but I think it will help those that can help you if you also answer the following question. What is happening that is not supposed to happen or what is not happening that is supposed to happen?

Ananya Suhas · Answer

Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate If uservalidate(Login1.UserName, Login1.Password) Then e.Authenticated = True Login1.Visible = False Session("user_id") = Login1.UserName Response.Redirect("home.aspx") Else e.Authenticated = False 'MsgBox("Invalid username/password", MsgBoxStyle.Information, "Mohire`s") End If End Sub Private Function uservalidate(ByVal username As String, ByVal password As String) As Boolean Dim boolreturn As Boolean = False obj.Connect() obj.cmd.CommandText = "select username,password from user_login" obj.dtr = obj.cmd.ExecuteReader While (obj.dtr.Read) If (username = obj.dtr("username")) And password = (obj.dtr("password")) Then boolreturn = True End If obj.dtr.Close() Return boolreturn End While Return boolreturn End Function THIS IS THE CODE I AM USING FOR AUTHENTICATION

Mahesh Chand · Answer

What do you mean by one user only? Are you trying to login as two users on the same machine? Can you tell us exactly what are you trying to do.

Sam Hobbs · Answer

More input please.

Login control not working

Answers (5)