Mask rows content in sql

Question

Hello everybody I've created a table to store login info created using windows form. The matter is that whenever i get in the database i can see user's password. So i want password rows content to be replaced by * or # caracter. Thx.

Kirtan Patel · Answer

Hi Here Is Example How to Encrypt Data in MD5 From String private void button3_Click( object sender EventArgs e) { string str = kirtan ; MD5 md = new MD5CryptoServiceProvider (); byte [] bytesofString = ASCIIEncoding .Default.GetBytes(str); byte [] EncodedBytes = md.ComputeHash(bytesofString); MessageBox .Show( BitConverter .ToString(EncodedBytes)); } Convert your data in Such a Format and Store in Database so that no one can read it :)

Fiston · Answer

Thank you even if you forgot to tell me the namespace to include first. I did it Thx.

Fiston · Answer

Thx But how can i manage the system you talked about. Thx again.

Kirtan Patel · Answer

Hi Friend You can not mask Content of row like MS Access in SQL Server but you can Encrypt your Data in MD5/SHA or RSA or Similer like that which is not readable by anyone