Each Parameter object contains a parameter that's passed to the stored procedure when it's executed. When using stored procedures, it's more efficient to explicitly create the command parameters rather than call the Command object's Refresh method to query the information from the database. Click here 6. This involves putting all the code that communicates with your database into objects. The goal of distributed architecture is to move logic and data access out of the client and into objects.
Objects offer the benefit of easier debugging and reuse, as well as simplified maintainability.
For example, you only have to change code in the data access layer if you decide to switch data providers, and your client application code remains untouched. You might need to spend more time in the design phase to ensure your data access layer provides the necessary functionality to the client. Click here 7. Typically, a query that returns publishers and the titles for each publisher creates a recordset in which the publisher information is duplicated for each title. The child recordset can be traversed and behaves as a normal recordset.