Encryption of SQL Express database

Hi!

Could you help me how could I encrypt an SQL Express database with a password?

The lines I currently use:

ssconn.ConnectionString = "Data Source=.\SQLEXPRESS;Integrated Security=True;"

CreateDatabase = "CREATE DATABASE i ON (NAME = i, FILENAME = '" & ssceconfilename & "')"
Dim myCommand As New SqlCommand(CreateDatabase, ssconn)
myCommand.ExecuteNonQuery()

I intend to encrypt the whole database structure so that nobody could see in.

I managed to do the encryption with SQL CE 2.0, but how to do it with express?

Thank you!

There is no command that encrypts the entire database in SQL Server Express. But you can encrypt data at cell level, before inserting it into a table.

Thanks
Laurentiu