decrypt data using SP on a windows form

[Manuel]

Hi forum,

Is there a tool/object that enables me to decrypt encrypted data from a sql server table and display it on a windows form?
I have an employee table with encrypted information. What i need to do is read the employee table to enable the user to see the employee information. I need to create 2 forms, one for inquiry and the other one for maintenance.
Obviously the maintenace will work the opposite, the user will enter information and i need to update the data using encryption.
I already have a Stored Procedured that does the encrypt/decrypt process.
I am new doing this and would like to use the winforms objects to do this.

Regards,
Manuel Roman

[Jack]

Hi Manuel,

There is no tool that you can use in this scenario. You have the following options:

1. Create a new query which executes the described SQL procedure and returns a plain (unencrypted) table.

2. Use the SqlCommand class to execute the particular stored procedure. Note that this can be a slow process because you should create a new connection with the SQL server for every record in your data.

3. You can implement the same encoding/decoding procedure in C# and execute it on the client side.

I hope this helps. Do not hesitate to contact us if you need further assistance.
 
Regards,
Jack
the Telerik team

[Manuel]

Thanks Jack,

I don't think i have the skills to do that.
i can create a query to extract unencrypted data but i don't know how to link it to my events table...

Regards,
Manuel Roman

[Jack]

Hi Manuel,

Please refer the following MSDN article, it describes how to use the TableAdapter class to get data stored in SQL database. You can modify the SQL query that gets the data and replace it with your query.

Regards,
Jack
the Telerik team