I am creating an MDI application that asks the user for a User ID and Password to be able to show personal details once verified. Details of user ids and passwords are available in a MS Access Table1. There is another table2 for user details, and another one yet for transactions made by the user table3.
I have created the connection from access to vb.net through OLEDB.
The only outcome I have managed to produce is a datgrid showing all users, all passwords, and all transactions for each and every user. I.e. >> OleDbDataAdapter1.Fill(dsTable()) :(
I need a procedure that asks the user for his ID and password, then once these are verified, only his appropriate details are shown. Example:
If txtUserID and txtPassword = True then
Show in label 1 Name
SHow in label 2 Surname
Can somebody help with code ?