Receiving Results
In ADO most commands result in some information returned to the caller. For commands returning rowset, the results are received in a Recordset object, which is probably the most used of the ADO objects.
There are several ways to receive data in a Recordset object from a data source, including calling the following:
- Connection.Execute method
- Command.Execute method
- Recordset.Open method
- Connection.NamedCommand
- Connection.StoredProcedure
Receiving data in a Recordset object concludes the process of getting data, with the participation of a Connection object and a Command object, implicitly or explicitly, as you have seen above. In a typical client/server application system, the whole process of getting data requires a round trip across the network for each filled Recordset.
To receive more than one result sets means you would need to make several round trips across the network, one for each data set encapsulated in a Recordset object. For slow or congested networks, reducing the number of round trips may help to improve the application's performances. To this end, some providers offer support to receive multiple Recordsets in a single round trip. This is discussed in the following topic: