Question passworddata in gridview

[bert aalders]

i'm new in programing vb and databases
i try to learn it myself.
i have a database i want to show in a datagrid
the database contains loginname and password.
The password is coded but i want to show it decoded in the datagridview.
it must be decoded before showing in the datagrid.
Can anyone help me?

 

[jmcilhinney]

Firstly, showing passwords in a grid is highly unorthodox and something that you should probably reconsider. Assuming you do want to go ahead, what exactly do you mean by "coded"? Do you mean encrypted or hashed or something else? The distinction between encrypted and hashed is VERY important because the whole point of hashing is so that the original value cannot be obtained from the hashed value, while encryption does allow the original data to be obtained.

 

[bert aalders]

What do you advise instead of a datagrid?
i always used a datagrid because i want to see al records, not 1 by one.
I have a database that contains users licensekeys.
the manager of these keys can read al the keys and can see them in de grid.
In de database itself the key is not readable.
i have an procedure that can read the key, decodes it and results in an readable key.
do you understand what i want?

 

[jmcilhinney]

A license key is different to a password. So apparently you have an encrypted license key. I would suggest that you populate a DataTable from the database as normal, add an extra column to your DataTable manually and then loop through the rows and decrypt each value, putting the result in the new column. You can then bind the data to the grid and hide the encrypted column.