ASP how to make a login with password?

Question

There's a table "Login" having values of "username" and 'password" coloumn's value in it. A login form in ADO.Net as frontend, and want to check if the value of "username and password" of form matches then the next form should be displayed. how should i do it with minimum lines of code.

Answer 1

1. Do not store plain text password in the database. Never.
2. The ASP.NET Login form has an OnLogin or something similar event. You need to attach a method to it.
3. Query the database for the credentials of the user that tried to log in. That is:

SELECT * FROM LOGIN WHERE USERNAME = @P_USERNAME;

Then you compare the password you got from the database with the password the user entered, and you're done.

Answer 2

Use the Membership provider instead. Than use the login control.

Bruno Figueiredo

Answer 3

For the least lines of code, use forms authentication and the asp login control:

http://msdn.microsoft.com/en-us/library/ms178331.aspx