Securing/encrypting sensitive data with clear display in DataGrid

From: Marc S. Gibian (marc.gibian_at_acm.org)
Date: 11/24/04 

Date: 24 Nov 2004 15:33:44 -0800

I have an application that contains some sensitive data. I am
displaying the table containing this data via a DataGrid, using an
ADO.NET DataSet for the database access. I need to make sure the
sensitive data is not stored in the database in clear-text, yet I need
to provide clear-text display to authorized users. I had thought
setting up an ItemBound event handler would do the trick, but while it
does solve the problem, performing the decrypting the data in the
handler and thus between fetch from disk and display to the user, it
did this at the cost of removing the field from the set of text boxes
made available when the DataGrid's EditItemIndex is set. Since I need
to allow the user to treat the field as a normal field, changing it
with any other non-read-only field in the grid, this is not an
acceptable solution.

I am looking for pointers to approaches to solving this problem. I am
sure this is not a unique issue, since any HIPPA compliant application
using a DataSet bound to a DataGrid surely would encounter this issue.
I just haven't hit on a search to find these solutions.

Relevant Pages

  • Re: How to refresh a datatable??
    ... then you don't need to requery the database ... > But I want to display the table IncomeProducts in the DataGrid like that: ... > And now I display this View on the DataGrid ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to refresh a datatable??
    ... Hello Bill! ... display all the updated data in the DataGrid (DataGrid is used to display ... > that your update is successful, the database and the local datatable ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: best way to tackle issue with writing Data, Appending Data and Rea
    ... data that I have read from my database and the two are related. ... would help me in my display of data in a grid. ... Read user input and store user input and DataRow to a file. ... display user input and data row in a DataGrid. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to avoid users pick same case
    ... The case number will be removed from the datagrid. ... I am using ADO and Access database which is located on the ... In a 'general' table I have a field named InUse. ... I display a message and skip. ...
    (microsoft.public.vb.general.discussion)
  • Re: Drop Down List for SQL Database
    ... list using the BindingContext. ... //Get the data from the database ... > This is the code im using to display in datagrid: ... > Can someone Please shwo me how to display this column in a DropDownList??? ...
    (microsoft.public.dotnet.languages.csharp)