What is the best way to simulate a SCAN or SEEK?

I've been doing this:

foreach ( int i in this.oDS.Tables["mytable"].Rows ) {check logic}