how to encrypt data into database?

Question

hello i want to encrypt password field in my table .i see the artical on but i doesnot understand it gives at the insert data . into table but when click on button the data i want to save in which pass is encrypted

i saw link "http://www.c-sharpcorner.com/UploadFile/syedshakeer/5626"

raghu v · Answer

hi, try with the follwing function which will return u the asyncronous one way encripted password public bool CreateEncryptedPassword(string UserName, string Password, out string EncryptedPassword) { sbFlag = false; HashAlgorithm hash = new SHA256Managed(); // compute hash of the password byte[] PasswordBytes = Encoding.UTF8.GetBytes(Password); byte[] PasswordhashBytes = hash.ComputeHash(PasswordBytes); // create key byte array byte[] KeyBytes = Encoding.UTF8.GetBytes(UserName); byte[] PasswordWithKeyBytes = new byte[PasswordBytes.Length + KeyBytes.Length]; for (int i = 0; i { PasswordWithKeyBytes[i] = PasswordBytes[i]; } // compute Key hash byte[] CombinedPasswordKeyBytes = hash.ComputeHash(PasswordWithKeyBytes); EncryptedPassword = Convert.ToBase64String(CombinedPasswordKeyBytes); if (EncryptedPassword.Length > 0) { sbFlag = true; } return sbFlag; } This code will return u the encrypted password for the combination of username and password which will be unique and the password cannot be decriptable so every time u need to get the encrypted password for the combination and then check with the database

how to encrypt data into database?

Answers (1)