Member Avatar for MondeVB

Hi everyone .

can you help me in making a log in form for administrator using the accounts from the MySql database .. i want to know the code in connecting database, because i am new in SQl database Programming.. example there are 2 fields in SQL database the Username and Password.. the elements inside the field Username is admin and in Password is asusTek. how can i trigger the user if he enter in the wrong Username and Password in two textbox in the form .... I am Using Visual Studio 2005 and my SQL is SQLExpress Edition with SQL server 2005

.... your help means a lot to me as a newbie in SQL database programming thanks
for any one who can give me a simple code of this .. I will accept your reply without any doubt thanks and god blezzz

  • 2 Contributors
  • 1 Reply
  • 109 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Since you are storing user name and password in database, user name field must be the PK of the table(so it is unique and can't be null).

Assuming the above criteria.

run the following query

SELECT COUNT (*) FROM TABLE_NAME WHERE USER_FIELD='USERNAME_THAT_YOU_ENTERED' AND PASSWORD_FIELD='PASSWORD_THAT_YOU_ENTERED'

If the above query returns one (the query will never return >1 as per the above assumption) you have passed correct credentials. In that case proceed further , else re-prompt for the login credentials.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.