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.

Answer 1

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 :)

Answer 2

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

Answer 3

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

Answer 4

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