ALTER PROCEDURE [dbo].[UIPKGUSER_spVerifyCredentials]
@inUsername varchar(100),
@inPassword varchar(100),
@outUserCount int output,
@outRoleName varchar(100) output
AS
BEGIN
SET NOCOUNT ON;
select @outUserCount = COUNT(*)
from tbluser
where username = @inUsername
and password = @inPassword;
if (@outUserCount > 0)
begin
select @outRoleName = rolename
from tbluser
where username = @inUsername
and password = @inPassword;
end
else
SET @outRoleName = '';
END
HERE IS CONNECTION string :-
DatabaseHelper.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultDB"].ConnectionString;
SEND ME LOGIN Right Code
This is Table
