Code:

private void TestFunction()
        {
            // C:\Documents and Settings\Administrator\dbPdaTest.sdf
            string connString = @"Data Source=\iPAQ File Store\dbPdaTest.sdf";
            SqlCeConnection sqlCeConn = new SqlCeConnection(connString);
            SqlCeCommand sqlCeCmd = new SqlCeCommand("select * from users", sqlCeConn);
            try
            {
                sqlCeConn.Open();

                SqlCeDataReader rdr = sqlCeCmd.ExecuteReader();
                while (rdr.Read())
                {
                    int num = rdr.GetInt32(0);
                    MessageBox.Show(num.ToString());
                }
            }
            catch(Exception ex)
            {
                string error = ex.Message;
            }
        }