How to save password in encrypted format in sql databse in asp.net

Hi,

Here is the solution

You can encrypt a password and can store a password as VarBinary in a column by using EncryptByPassPhrase function. Encrypted column can be decrypted using the DECRYPTBYPASSPHRASE function.

Now while inserting the password filed into the table

INSERT INTO login_details(uid,username,password) VALUES(1,'smith',EncryptByPassPhrase('12','XXX'))

It will insert the value into the DB in encrypted format,while decription pass the same encripted value into the DECRYPTBYPASSPHRASE function

Thanks,
Prasant