Question Encrypted Dataset Column

[Gr1m]

Hi,

I need a way to handle an encrypted column in a dataset. I have controls bound to a datasource, one of the column is a password column. I need this to show something meaningless (like the encrypted value or a blank) but when something is entered it must be encrypted and saved to the db?

Thanks in advance

Regards

Ed

 

[cjard]

er.. why are you downloading the password column at all if you don't want it to show?

 

[Gr1m]

Well, it doesnt need to be loaded, but I need the dataset to be able to handle updating it by encoding the value before it is stored.

 

[cjard]

Er. That's a little confusing, but it sounds like you want to ahve a datatable that has a Password column

BUT DON'T bind it to anything, don't select it in the tableadapter SELECT queries, and when the user types something in it (er.. maybe i would use a password field instead for obfuscation) have the db server do the encode.

Perhaps if you tell me more about the screen youre desigining and its purpose I can suggest a solution