Validate username and password

Closed
aby - 9 Nov 2009 à 04:34
bytelogik Posts 8 Registration date Monday 5 October 2009 Status Member Last seen 9 November 2009 - 9 Nov 2009 à 15:41
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 5 October 2009 Status Member Last seen 9 November 2009 12
9 Nov 2009 à 15:41
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.