can any one help me in encrypting & decrypting my database using c#

In my database i hv a field name Money its data type is money.
I want to encrypt this field while records are inserted.
I am able to encrypt all the text fields except this.
I am using asp.net c# with sql server 2000.

what do you mean by encrypting money filed. Please explain

Regards
Ganesh
http://ganeshprof.blogspot.com

in my database i hv a field name Money whoes data type is money.
I want to encrypt this field while records are inserted.
I am able to encrypt all the text fields except this.
I am using asp.net c# with sql server 2000.

I am going to assume that when you take the value, say $120.58, and encrypt it to a string (MD5, SHA, RSA, Base64, etc) SQL is probably telling you something like this:

"String value [encrypted string] cannot be inserted into column money of type money; Insert fails."

What you will have to do is change your column type from Money to Nvarchar to store that information because, at the point you encrypt the information, it is no longer "money" it is an encrypted string.

Hth.

"The one language all programmers understand is profanity."