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. In a typical client/server application system, the whole process of getting data requires a round trip over the network for each filled Recordset.

To receive more than one result sets means you would need to make several round trips over 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 improve the application's performances. Therefore, some providers offer support to receive multiple Recordsets in a single round trip. This is discussed in the following topic:

• Receiving Multiple Recordsets