Encryption and database question

[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

 

[Ginny Caughey [MVP]]

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.

 

[Joseph Byrns]

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.

 

[Ginny Caughey [MVP]]

Good point, Joseph.