Business solutions Automating Microsoft

17. Manipulating Data with ADO

IN THIS CHAPTER

Moving Through a Recordset

Finding Data in a Recordset

Adding Data Using a Recordset

Deleting Data in a Recordset

Updating Data in a Recordset

Using Transactions to Commit Groups of Records—or Not

Moving Through a Recordset

After you retrieve data using an ADO Recordset object, you’ll want to manipulate that data in some way, even if all you want to do is view the data. A lot of what you learn in this section you can also use to find, add, delete, and edit existing data.

Moving through a Recordset actually requires setting the current record pointer within the cursor (the retrieved data). In other words, you point to a specific record making it the current record pointer. To move about the ...