This design has the advantage of making my code simpler, and avoiding the record pointer reset required when using the recordset object. In fact, using a datatable object is so much easier than dealing with the legacy ADO recordset, you may want to use this method for handling in-memory data sets even if you don’t need to process the result set multiple times.

I’m going to spend time in my next post going over the last bullet in that list, to demonstrate how this method behaves with multiple result sets from a single query.

A For Each Loop container to loop through the list stored in this variable

Supported: It does not start a new transaction, but it will join an existing transaction (if any).