Listing 1

SqlCeC on cn = null;

try
{

    SqlCeConnection cn = new SqlCeConnection("Data Source = birds.sdf");
    cn.Open();

    SqlCeCommand cmd = cn.CreateCommand();

    cmd.CommandText = "SELECT * FROM Birds ";

    SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable | 
	  ResultSetOptions.Scrollable);

}
catch (Exception e)
{
    MessageBox.Show(e.Message);
}
finally
{
    cn.Close();
}