decrypt data using SP on a windows form

4 posts, 0 answers
  1. Manuel
    Manuel avatar
    2 posts
    Member since:
    Apr 2013

    Posted 12 Apr 2013 Link to this post

    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
  2. Jack
    Admin
    Jack avatar
    2333 posts

    Posted 16 Apr 2013 Link to this post

    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
    WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Manuel
    Manuel avatar
    2 posts
    Member since:
    Apr 2013

    Posted 16 Apr 2013 Link to this post

    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
  5. Jack
    Admin
    Jack avatar
    2333 posts

    Posted 19 Apr 2013 Link to this post

    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
    WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
Back to Top