Scrambled SSN's 2

[hitechboy78737]

Does anyone have a suggestion to scramble a SSN before saving it to a database AND unscrambling it when retrieving the field.

Thanks!
Kevin Howell
Briefcase of Talent
Austin, Texas

 

[NoCoolHandle]

How about using the encryption providers? They really arn't too hard to use and are extreemly powerfull..

Check out

http://www.dotnet247.com/247reference/System/Security/Cryptography/DESCryptoServiceProvider.aspx

for examples etc...


HTH


Rob

 

[chiph]

Are you worried that the database will fall into unfriendly hands? Or is there reporting being done off this database?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[khowell78737]

The database would reside on a laptop, that could walk away. I don't think the client has considered this scenario, but I thought of it the other night and decided to do something about it on my own if the solution was simple and "free".

Kevin Howell

 

[chiph]

Then I would use the encryption code that NoCoolHandler linked to. If there's any HIPAA data on the laptop, I'm pretty sure the law would want it protected.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[hitechboy78737]

Well, can someone guide me to a VB based resource (the link is c#) about how to encrypt a peice of data?

thanks

 

[chiph]

All the library code in there is from the .NET framework, and works the same no matter which .NET language you're using. The big differences are how variables are declared.

In VB.NET, you say:

Dim myVar As SomeType
myVar = New SomeType()

In C#, you say:

SomeType myVar = new SomeType();

So you just reverse the name of the variable with the type. Not too hard.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[hitechboy78737]

Thanks! My problem was just reading a "foriegn" code, but looking at it from the perspective you showed me helped alot.

kevin howell