i have a form, on that form i have a username and password text field, also i have a login button.
theres a table in the database which has a username and password fields.
the question is, when the user enters a username and a password and presses LOGIN, how do i do a comparision against the table so if the information matches a record in the table the user is directed to form2.
the database is done in sqlserver2000, and its a windows application in vb.net.

Cross post: http://p2p.wrox.com/topic.asp?TOPIC_ID=15116