I need to create a login access form using ASP.NET. The code i'm using is VB.NET. This access form has to link to my SQL Server database. I need to validate the username and password from the database and also the access right to either admin or user.

If username and password valid then
     If access right = "admin" then
     Response.Redirect ("admin.aspx")
     Else
     Response.Redirect ("user.aspx")
     End If
End If

How should i go about writing the code? The username input in the loginpage is also required for me to track the full name in my database and display it on the other webpage. Can anyone help me? Thank you very much