Guest User

Guest User

  • Tech Writer
  • 529
  • 36.1k

stored procedure use in login Sent Me Right Code

Apr 21 2022 6:32 PM
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)