How to change password from database?

Question

0.00/5 (No votes)

See more:

, +

Hi, I'm implementing a Homepage for a Website, using MVC 5 and SQL and I'm having a issue with the password changing part.

I'm hashing the password and using "salt" on it. But when I try to change it through SQL, it ignores my

SQL

update users
set Password = @sPassword

Am I doing something wrong in regards to the idea overall? It should be a simple process. And I have the email changing going correctly. But not the password probably due to this hashing thing, can someone share some thoughts?

Thanks.

Posted 13-Oct-14 7:33am

Zamuk

Updated 13-Oct-14 8:29am

Afzaal Ahmad Zeeshan

v3

Add a Solution

Comments

[no name] 13-Oct-14 13:52pm

1.) What error Message? Duplicate blabla ....for field Password ?
2.) You really like to assign same Password for all users, or you simply not Show the WHERE clause in the SQL snippet?

VC.J 13-Oct-14 13:57pm

the query must be something like update Users set Password =@password where UserID=@userID

Zamuk 13-Oct-14 14:11pm

Yes I have that

Zamuk 13-Oct-14 14:11pm

Ok I found my main issue.
I have a password for a user1 in my database. (with a certain hash)

When I attempt to do a password change and I retype the former password, in order to validate that I am the user1, the program is ready a completely different hash. Resulting in a return -1 in SQL. is this supposed to happen?

VC.J 13-Oct-14 14:13pm

great :) are you using execute scalar

Zamuk 13-Oct-14 14:14pm

My issue still remains though ahah, I've found it's source not it's solution ^^

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

VC.J · Accepted Answer · 2014-10-13T08:23:00

Solution 1

I am not able to replicate your issue at my end
you can see those link for hashing may be that can help you
Salted Password Hashing

and
MSDN LINK

Posted 13-Oct-14 8:23am

VC.J

Updated 14-Oct-14 19:44pm

v2

Comments

aarif moh shaikh 14-Oct-14 2:44am

exactly from my side....