i need to authenticate users against an existing DB (sql2005). I already have a table with Username, Password and AccessLevel (Admin, Manager, User).
The out-of-the-box Forms authentication offered by Visual Studio2008/ASP.NET does not meet my needs. Only manager(s) will add/edit users to the database. Users can log in, change their temp password (once or more) and can only view/edit some of the pages.
I created the login.aspx page but when i press the "login" button i don't know how to write the code to pass the username/password parameters, open a connection with the db, run the proc to check if username and password are matching, etc.
i spent all day on google but i haven't quite found anything that helped me.
Can anyone help me out?
View Complete Post