• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Retrieving Data with ADO > Working with Command Objects

Working with Command Objects

You can use the Connection or the Command object to retrieve and manipulate data. However, the Command object has a few advantages:

  • Using a Command object, you can avoid a Recordset object and update data directly, which can be faster with some databases because the changes are made on the server instead of dragging the records across the network.

  • The Command object supports parameters; the Connection object doesn’t.

  • The Command object has more properties than the Connection object, which enables you to fine-tune its behavior.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint