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

Gaurav Raj

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munish Kumar7y ago
Accepted 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
Gaurav Raj7y ago
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
Munish Kumar7y ago
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
Gaurav Raj7y ago
Hi Munish Sir ...I correct My Mistake But its not Working Me..
Jignesh Kumar7y ago
Hi Gaurav,

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

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

Hi Munish Kumar Sir