SQLCeconnection On Visual Basic And Insert Data On A Listbox

Hi

I am developing a program on Visual Basic 2005 to a pocket pc, I want to make the SQLceconnection but It says that the file doesn´t exists, I use this code:


Dim conn As New SqlCeConnection()

Dim Recordset As SqlCeDataAdapter

Dim SQL As String

Dim ds As New DataSet

conn.ConnectionString = _

"Data Source = '.BDDclimatologicos.sdf';"

conn.Open()

SQL = "select [Provincia] from ZonasClimaticas"

Recordset = New SqlCeDataAdapter(SQL, conn)

Recordset.Fill(ds, "ZonasClimaticas")

lstboxProvincias.DataSource = ds.Tables("ZonasClimaticas").DefaultView


I have Dcilmatologicos.sdf on a folder named BD next to the folder of the executable, I don´t know what happends.

My database has one table "ZonasClimaticas" and a column named "Provincia" on that, my other question is:

Is this the right code to show that column on a listbox?

Thank you very much!