I am relatively new to programming and could use some direction from someone more experienced.

What I am trying to do is create a login routine for a VB.Net app I have created. I need to promp the user to enter a username and password, then compare their password with the password field in a SQL Server database for their userid. If they match, then go ahead and open the first form in the app.

Basically I need someone to show me the syntax I should follow to connect to the database, formulate and run a select statement based on the userid they enter in the textbox, then compare the password they entered in a textbox to the one in the database. I'd like to use ADO.NET, but if there are other ways to do this, please feel free to respond. Thanks in advance!