ASP user name password login authentication code with Database

With the database of ASP username password login Authentication code, this code has the full logic of login judgment, including the connection database, query to determine whether the user name and password is correct, return to refill, close the database recordset, etc., for the ASP beginners have a good reference value:

Here is connected to the SQL Server database, the database is not uploaded, there are two fields, name is stored user name, UserPassword is the password field, create their own manually, modify the code inside the database connection information can be tested.