how to store the password in encrypted mode?

DECLARE @PlainText NVARCHAR(MAX)
DECLARE @CipherText NVARCHAR(MAX)


SELECT @CipherText = EncryptByPassPhrase('sss','Sandeep');
PRINT @CipherText


SELECT @PlainText =CONVERT(VARCHAR(MAX),DecryptByPassPhrase('sss',@CipherText));
PRINT @PlainText


Now You can you both variable in fruhter.

OR
FOR SQL SERVER
http://www.c-sharpcorner.com/UploadFile/chinnasrihari/data-encryption-and-decryption-in-sql-server-2008/

FOR C#

http://www.c-sharpcorner.com/UploadFile/dhananjaycoder/triple-des-encryption-and-decryption-using-user-provided-key/