Display Encrypted and Decrypted data from database in Windows Forms DataGridView using C# and VB.Net

Question

Article Encrypt and Decrypt Username or Password stored in database in Windows Application using C and VBNetI have a vbnet program which uses a database with 5 fields is it possible to encrypt the fields into the database and the decrypt to DataGridView to see unencrypted records

dharmendr · Accepted Answer

Hi  jshorthoseI have created sample using the article Encrypt and Decrypt Username or Password stored in database in Windows Application using C and VBNetPlease refer the below exampleDatabaseI have made use of the following table Customers with the schema as followsI have already inserted few records in the tableYou can download the database table SQL by clicking the download link belowDownload SQL fileNamespacesCusing SystemIOusing SystemTextusing SystemDatausing SystemDataSqlClientusing SystemSecurityCryptographyVBNetImports SystemIOImports SystemTextImports SystemDataImports SystemDataSqlClientImports SystemSecurityCryptographyCodeCprivate void Form1Loadobject sender EventArgs e    string constr  34Data SourceSQL2022Initial CatalogAjaxSamplesUIDsaPWDpass12334    using SqlConnection con  new SqlConnectionconstr            using SqlCommand cmd  new SqlCommand34SELECT  FROM Customers34 con                    us

Display Encrypted and Decrypted data from database in Windows Forms DataGridView using C# and VB.Net

Company

Explore

Follow us

Contact Us