Dear experts,

I have a MS SQL table, let's called it "year_end", there is a column with sensitive data called "customer ID", I would like to hash the "customer ID" column by the identity column and then load it into a new table row by row with the hash result. Example:

The "year_end" table:

name varchar(30)
address varchar(30)
customer_ID char(9)


The new "year_end" table:

name varchar(30)
address varchar(30)
customer_ID ???? (hash value)

I need the codes in C# to do this. Do I use Console application to do this or ASP.NET? I am new to C#.

Thanks in advance.

Well I can see now reason to do it as a ASP.Net web application, unless you have a need for a cross browser interface to this 'functionality'. Either way the code will be the same.

I'd recommend a MD5 hash of the column. A simple search for "MD5 C#" should provide you with the samples you need.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?

As an alternative I'd take a look at SQL Server's built-in encryption features.

__________________
Joe
http://joe.fawcett.name/