I've written some notes about various iterators in the MicroStationAPI. I find it useful to have a summary that provides an alternative to the documentation.
There are several web pages about different sorts of iteration. I've referenced the legacy MDL equivalent so you can see how to do things the CONNECT way compared to the historic MDL way.