How to encrypt only certain columns in a data table?

[dla0313]

Hi All,

As the title mentions, I am having lots of issues with encrypting only specific columns in a data table. Unfortunately, I can’t encrypt the entire table due to certain requirements. I keep receiving an error saying “Exception has been thrown by a target of an invocation” so I’m not sure exactly how to resolve this. I tried following the EncryptColumValuesCurrentApproach.xaml in this discussion post (An alternative to encrypting or decrypting column values of a datatable?).

Unfortunately none of these options seem to be working for me as my data table is being extracted from a database so the column structure is automatically assigned. I also tried to clone the table into a new one and assign all the values to a string, but that didn’t work either. Please help!