Validate username and password

Closed
aby - Nov 9, 2009 at 04:34 AM
bytelogik Posts 8 Registration date Monday October 5, 2009 Status Member Last seen November 9, 2009 - Nov 9, 2009 at 03:41 PM
Hello,
i am creating a login page in asp.net using vb.i want to validate username and password from the database sql server 2005 .what is the code for validating username and password from database via the application.ifboth the username and password is corrrect the user should directed to next page..so what steps i want to do in database and in the application?

1 response

bytelogik Posts 8 Registration date Monday October 5, 2009 Status Member Last seen November 9, 2009 12
Nov 9, 2009 at 03:41 PM
Obviously you need to equate the user input (Usename and Password) with that of database Username and Password.
Have you written code for this. If you have any errors, mention it.

Steps:
Database : Create Database -> Create Table -> Add 2 fields UserName and Password -> Store defalut values

VB:
Use textboxes for UserName and Password
OpenDatabase ->Retrieve the table record using SQL query -> check if the data matches with the values in the textboxes.
0