Dim query As String = "Orders"
Dim conn As New CEConnection(connString)
Dim cmd As New CECommand(query, conn)

conn.Open()
Dim rdr As CEDataReader = cmd.ExecuteReader()

Try
   ' Iterate through the results
   '
   While rdr.Read()
      Dim val1 As Integer = rdr.GetInt32(0)
      Dim val2 As String = rdr.GetString(1)
   End While
Finally
   ' Always call Close when done reading
   '
   rdr.Close()

   ' Always call Close when done reading
   '
   conn.Close()
End Try

string query = "Orders";
CEConnection conn = new CEConnection(connString);
CECommand cmd = new CECommand(query, conn);

conn.Open();
CEDataReader rdr = cmd.ExecuteReader();

try
{
   // Iterate through the results
   // 
   while (rdr.Read())
   {
      int val1 = rdr.GetInt32(0);
      string val2 = rdr.GetString(1);
   }
}
finally
{
   // Always call Close when done reading
   // 
   rdr.Close();

   // Always call Close when done reading
   // 
   conn.Close();
}