How to make a login system with a database (vb)?

I want to make a login system using vb 2008 EE, and I want to be able to create an account that inputs the info right into the database and login using info from the database.



Please someone help!How to make a login system with a database (vb)?
I am giving below the outline of the login action.



1. get connection to the back end data base

2. validate inputs, like non-empty username value and non-empty password values

3.run the query of the following pattern on the backend database and store the results

select password from %26lt;table name%26gt; where user name = %26lt; user name obtained form the user%26gt; from %26lt;table name

4. Since username in the database is unique, you will get either a null or one value

5. Check the value - if null display the message '; Username not valid'; and exit

6. If the value is something, then compare it with the value that the user had given.

7. If they are both the same, display message of ';successful login';. If not display message ';incorrect pssword';

8. In case of incorrect username or incorrect password, display the login page afresh.

I think that's all to login form.