To move to the first record in the result set, call the MoveNext method, which initializes the cursor and moves it to the first record. You can now use the methods of ResultSet to obtain information about the fields of first record.
To move to subsequent records, use the MoveNext method again. You can now use the methods of ResultSet to obtain information about the fields of the current record.