Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blanc
Starting Member
2 Posts |
 Posted - 2005-11-16 : 19:24:15
|
| Hi, I have a login form in Visual Basci Ex 2005 and would like to know how to make the program search for the recordthat has the login, get the password and compare them to give or deny access. THanks |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2005-11-16 : 20:36:31
|
| Well,Get your typed in username and pwdwrite a stored procedureand pass in the username and pwd.then simply do a query, and in your VB program, you can check to see if anything was returned and determine the success/failure option________________________________________________Drinking German Beer... fun.Listening to an accordian player play ACDC...priceless |
 |
|
|
blanc
Starting Member
2 Posts |
Posted - 2005-11-17 : 16:37:31
|
| Thanks, I dont know a lot of SQL so could someone give me an example of how the query would be, egSQL find (logintext) and output none or password value. Check that password.text = password Output.I know basic and to do queries, but I dont know how to tell the program that logintext is the input and especially to name the output, eg If SqlOutput.text=password.text Then...How do I name SqlOutput.text?Bye... |
|
|
|
|
|
|
Login Query