Data Access and Transactions

Managing Records in a Recordset

No discussion of the ADO Recordset is complete without talking about how a developer can use it to accomplish the task at hand. In other words, how do you best use a Recordset object to add new records, delete and update existing ones, and work through the results of queries? Although this section describes a few techniques to help you through the more troublesome aspects of ADO Recordset management, it is not intended as a complete tutorial of ADO development. For more information, see the IIS 5.0 online product documentation.

See the following:

• Keeping Track of New Records
• Avoiding Query Time-outs
• Purging Deleted Records
• References to Field Values
• VBScript Example: Filling a List Box
• PerlScript Example: Filling a Table
• Limiting the Number of Records
• Visual Basic Example: Paging through a Recordset
• Retrieving Image Data

© 1997-1999 Microsoft Corporation. All rights reserved.