A1VBCode Forums

Help with Database Query in VB2008


http://a1vbcode.com/vbforums/Topic28351.aspx

By Booster1977 - 11/10/2009

Hi everyone!



I've worked with Visual Studio for a couple of years, but it's been a while. I'm trying to build a database driven application, but I can't figure out the new system with the tableadapters and such.



What I'm simply trying to do (to get started) is to compare a username and a password provided in a textbox, with those in the database.



I do understand SQL queries very well so that's not the problem. My question is, what on earth do I put down when I:



Have a table 'users'

that holds a column Username and a column Password

String userinput is what the user entered as username and string passwordinput is what the user entered as password.



I tried to make a query in the tableadapter, that worked fine, but I can't seem to get the output anywhere. If I know how this works I can continue building. So if you guys could give me a head's up that would be most appreciated!



Thank you so much in advance.



René