Problem with Login check from SQL DB

[berilker]

Hi, i have a project which is hospital automation software. I need to set a login screen for users to access different forms according to their access rights. I have a table in my sql database(sql server 2008) with user records, each user has an id no and password in table. I created a login form with id and pass textboxes in it but i dont know how to compare them from database and complete the login action. How can i do that?

[ThatThatGuy]

pass a query to the database something like this...

select Count(*) from Users where id like 'userid' and password like 'pass'

and if 1 is returned then the user credentials are valid

[berilker]

thank you thatthatguy it worked ;)