Call the sp from c# and fill it in a DataTable and then count the rows of the datatable

PHP Code:
select from login where usrname='abc' and password='123' 
if the number of rows is zero the login is incorrect if the rows returned is 1 then the credentials are correct...

remember you will have to disallow the use of these characters * ; '' @ etc so that there are no injections...
coderzone like this