Hi

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
etc etc

Can somebody help with code ?

while you configure your data adapter , the sql statment will be something like this

the question mark means that you will select specific row based on id (primary key)
then in your code you will verify that user entered correct information . after that replace the question mark with value you got from the user




hope that help you