windows mobile常用数据库对象应用

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();            }