I am Try to login with store procedure ......see my code

Question

insert into RegisterTable (Name,email,HashPassword,ActivationCode,verify)
values ('qwert','[email protected]',HASHBYTES('SHA2_256','12345'),124,0)

CREATE PROCEDURE [dbo].[LoginProcedure]
    @Email varchar(50),
    @HashPass nchar(32)
AS
    SELECT * from RegisterTable
    where email=@Email and HashPassword =HASHBYTES('SHA_256',@HashPass)
RETURN 0

Munish Kumar · Answer

There is a difference between your HASHBYTES method in insert and select statement: Insert: HASHBYTES('SHA2_256','12345') Select: HASHBYTES('SHA_256','12345') SHA2_256 or SHA_256

Munish Kumar · Answer

Hi Gaurav, First try to run the below query in your SQL: select HASHBYTES( 'SHA1' , '12345' ) as 'SHA1' , HASHBYTES( 'SHA2_256' , '12345' ) as 'SHA2_256' , HASHBYTES( 'SHA2_512' , '12345' ) as 'SHA2_512' See which algo returns you result. In my case, it is SHA1. Go with the one which return results. It is good if you get results with your existing one i.e. SHA2_256. Second thing, I have modified your procedure, try it. Let me know if you need any further help. ALTER PROCEDURE [dbo].[LoginProcedure] @Email nvarchar(50), @HashPass binary (32) AS SELECT * from RegisterTable where email=@Email and HashPassword =@HashPass

Jignesh Kumar · Answer

Hi Gaurav, Please try below link https://www.aspsnippets.com/Articles/Validating-Check-Username-and-Password-from-database-in-ASPNet.aspx

Gaurav Raj · Answer

Hi Munish Kumar Sir Thanksyou for reply me..... But I have Solved My Problem Myself this Is My solution CREATE PROCEDURE [dbo].[LoginProcedure] @Email nvarchar(50), @HashPass varchar(max) AS Declare @pass varchar(max) set @pass=@HashPass SELECT * FROM RegisterTable WHERE email=@Email and HashPassword=HASHBYTES('SHA2_256',@pass) RETURN 0

Gaurav Raj · Answer

Hi Munish Sir ...I correct My Mistake But its not Working Me..

I am Try to login with store procedure ......see my code

Answers (5)