We help IT Professionals succeed at work.
Get Started

Logon Control in Visual Studio 2008 in Visual Basic with SQL Server 2005

Last Modified: 2012-05-12
I have created a table in SQL 2005 that has userLogonId (primary key) and userPassword columns. I have used the Login tool under the Login Category of Toolbox in Visual Studio 2008. I have used a connectionString in the vb page to connect my data source to my drop-downList in order to SELECT items, yet I have no clue what code is needed to search through my table and see 1 if my Logon exists, and 2 if the password is in the same row.
I have googled this to death and serached "help" in Visual Studio yet there are no scripts for this given and I don't know Visual Basic (now if I need to write a script in Java.. but does me no good here).
Since you helped me soooo much on my last question, I would greatly appreciate assistance on this one. If I could award more than 500 points, I woul. This has really stumped me!
Here is what I have so fat http://comweb.uml.edu/elamo57769/project1/userAdmin.aspx
Watch Question
Most Valuable Expert 2012
Top Expert 2014
This problem has been solved!
Unlock 3 Answers and 23 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE