asked on

VB & SQL - Verify Password stored in SQL from VB and show that particular record of that password in VB Form.

I need my visual basic application to show me the record of a specified ID or password stored in SQL...
I can connect and view the files and so on.... but i cant seem to specify the record that i want to view...
For example... I need to type in the ID which is 99999 in visual basic...
Then it must look up in SQL for that ID and show me the record for that ID only....
If possible, I should edit, or delete the record....

I am using VB6 and MS SQL 7...
I really need the code in visual basic to complete my task...

Hope you can HELP ME
Thank You So Much...

Piter

you have to use Privileges in your database.
else
you can declear userid as public in ur Module and check it in all forms.As it is decleared as public it will be available in all forms.
then on form_load you can check for userid and can display replated records for that USER_ID.

in MODULE :
public useid as String.

in form :
if userid = "999999" then
Display records those you want to get from database.
end if

ASKER CERTIFIED SOLUTION

Ysgrathe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cerebralpc

icefx,
No comment has been added lately (141 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to Ysgrathe http:#8165934

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

cerebralpc
EE Cleanup Volunteer

https://www.experts-exchange.com/questions/20555923/VB-SQL-Verify-Password-stored-in-SQL-from-VB-and-show-that-particular-record-of-that-password-in-VB-Form.html

VB &amp; SQL - Verify Password stored in SQL from VB and show that particular record of that password in VB Form.

VB & SQL - Verify Password stored in SQL from VB and show that particular record of that password in VB Form.