12
Answers

stored procedure use in login Sent Me Right Code

Guest User

Guest User

2y
894
1
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

Answers (12)