Data encruption

[rohitpabby]

Hi there!

I am using SQL Server 7.0 as my databse and ASP as front-end. I want to store data in one on the columns on a table e.g. salary as encrypted data so that no one can read it and want to display decrypted data when the administrator logs in and tries to view the salary detils. Can somebody help me how to do this?

Thanks.

Warm Regards,
Rohit Pabby.

 

[GabeC]

http://www.planet-source-code.com

has many examples of string encryption.

Here is one that I have not tried but it sounds like it is close what you want. You just need to modify it to do exactly what you need. You would encrypt the string before storing it in the database and then decrypt it before displaying the value to your web page if an admin is logged in.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=8527&lngWId=1