string dest = "mytest.sdf";
SqlCeConnection cnn = new SqlCeConnection("Data Source =" + dest);
try {
cnn.Open();
SqlCeCommand cmd = cnn.CreateCommand();
cmd.CommandText = "select name from test";
SqlCeDataReader rdr = cmd.ExecuteReader();
while (rdr.Read()) {
this.label1.Text = rdr["name"].ToString();
}
rdr.Close(); cmd.Dispose(); cnn.Close(); MessageBox.Show("Ok"); } catch (SqlCeException err) { MessageBox.Show(err.ToString()); } finally { cnn.Dispose(); }