If you want to check through a stored procedure that whether the username and password used in the login process is correct or not, then you may use an output parameter in the stored procedure.
Declare an output parameter as follows:
Declare @result as int out
Suppose table name is tblInfo
select @result = count(*) from tblInfo where username=@username and password=@password
If this output parameter return a value greater than 0, which may be checked din the front end, then the login credentials are correct, otherwise its false.
For further details you may visit us @ http://www.industrialtrainingkolkata.com/?cat=12
Besides, you may also join our 100% Job Oriented Practical training on ASP.NET with C# and SQL Server. You may call us @ 9830386818/09831709190.