ASP and Databases

[Reachster]

Hey, I need some information please, Can i get, if possible some examples of database connected to ASP website in ASP source code, If not answer these two qtns if you can 1) How can i make it so that when someone signs up it goes into my database. 2) How is the login verified when people have signed up and are attempting to login with their password. Thanks whoever can helpReachster

[Jerome]

Everything you need is just right here : http://www.w3schools.com/ado/default.asp

[logz]

2) How is the login verified when people have signed up and are attempting to login with their password. Thanks whoever can helpReachster

<{POST_SNAPBACK}>

You need to create a login form with the fields USERNAME and PASSWORD.When you click login, you need to be taken to a new ASP page.On that page, you need a program which saves the username and password collected from the login form to a variable.Use the USERNAME variable to then search your database for the username and password. IE:SQL:SELECT username, userpass FROM login WHERE username='" & request.form("username") & "'"Then, assign these two entries you've collected from the database to two other variables. for instance: collected_username and collected_passwordYou then need to compare the password submited via the login form to the password collected from the database using the IF ELSE function.IF request.form("username")=collected_username AND if request.form("password")=collected_password THENresponse.redirect("controlpanel.asp")ELSEresponse.redirect("failed.asp")END IF

[degsy]

Here is a basic tutorial http://www.kamath.com/tutorials/tut003_auth.asp