Changing columns content before binding to windows control

[Spatz]

Hello all,

I have created a dataset with a datatable in it. A dataadapter fills
the datatable with username, password, first name, etc.... Then I put
the datatable in the dataset. The password is encrypted before it is
saved to the db. So when the datatable is filled with the password
column the value is encrypted.

Here is the problem. I have a c# function that encrypts and decrypts
the passwords. I need to decrypt the column in the table using the c#
function. If I bind the column to a control:

ie. [txtpassword.DataBindings.Add("Text", m_ds,
"Customers.Password");]

then the text in the textbox is encrypted.

Is there a way to tell the bound control to use the data in the table,
but call a c# function to manipulate it before displaying?


Thanks in advance,
Tom

 

[Rajesh Patel]

One way is, you can decrypt column values when you load data to datatable
after fetching from database and encrypt it before you send it to database.

Rajesh Patel

 

[Spatz]

Rajesh,

Thank you for your response. This is the solution I came up with and
is currently implemented. I was just curious if there was a .NET
automated way to handle this.

Best Regards,
Tom

One way is, you can decrypt column values when you load data to datatable
after fetching from database and encrypt it before you send it to database.

Rajesh Patel

Hello all,

I have created a dataset with a datatable in it. A dataadapter fills
the datatable with username, password, first name, etc.... Then I put
the datatable in the dataset. The password is encrypted before it is
saved to the db. So when the datatable is filled with the password
column the value is encrypted.

Here is the problem. I have a c# function that encrypts and decrypts
the passwords. I need to decrypt the column in the table using the c#
function. If I bind the column to a control:

ie. [txtpassword.DataBindings.Add("Text", m_ds,
"Customers.Password");]

then the text in the textbox is encrypted.

Is there a way to tell the bound control to use the data in the table,
but call a c# function to manipulate it before displaying?


Thanks in advance,
Tom