Encryption and database question

  • Thread starter Thread starter Zalek Bloom
  • Start date Start date
Z

Zalek Bloom

Hello,
I wrote an application for PocketPC in VB.Net that is using a database
table where one column on a table is password protected. The
application is working OK, but the content of the table can be seen
using Query Analizer application. I can encrypt this column, but maybe
there is a simpler solution. My questions:

1. is there any encryption class in vb.net or I have to create my own
encription?

2. Is there a way to store all table encrypted so the Query Analizer
will show the table only after a correct password is supplied?

Thanks,

Zalek
 
Zalek,

You can password protect an entire database using SQL CE or SQL Mobile. This
would be the easiest way to accomplish your goal since the password would be
needed before you could even open the database. Alternatively there are
encryption classes on www.opennetcf.org.
 
Also CF V2.0 has the Cryptography class available
(System.Security.Cryptography) where you can find the MD5 Hash to apply to
you passwords before entry into the database.
 
Back
Top