You are free to copy and use any of the samples supplied on this website for
use in your own projects, provided that all copyright notices remain intact as
part of the code. You may not publish the code to any website or other medium
without the express written permission of the copyright holder. Each sample is
provided on an "as is" basis. No warranty is expressed or implied, and no
support is offered.
ADO
|
| Creating & using a persistent
ADO Recordset |
How to persist
(save) an ADO recordset to XML or ADTG format, and how to work with data
persisted in such files. |
| Creating an ADO Recordset from
a Command object |
How to create an ADO
recordset using an ADO Command object. |
| Creating a shaped ADO
Recordset |
How to create & use
shaped ADO recordsets. |
| Creating schema Recordsets in
ADO |
How to create & use
ADO schema recordsets. |
| Disconnected ADO Recordsets |
How to create & use
disconnected ADO recordsets. |
| Editing ADO Recordset data |
How to edit ADO
recordset data. |
| Opening an ADO Recordset
containing multiple SELECT queries |
How to use an ADO
recordset containing multiple SELECT queries. |
| Find |
Using the Find
method to find data in ADO recordsets. |
| Seek |
Using the Seek
method to find data in ADO recordsets. |
| |
|
DAO
|
| FindFirst |
Using the FindFirst
methods to find data in DAO recordsets. |
| Seek |
Using the Seek
method to find data in DAO recordsets. |
| Cancelling a DAO Recordset
edit operation |
How to cleanly
cancel adding/editing data in a DAO recordset. |
| Creating and using DAO
Recordset clones |
Using DAO Recordset
clones. |
| Opening a DAO Recordset
containing multiple SELECT queries |
How to use a DAO
recordset containing multiple SELECT queries. |
| Using arrays with DAO
Recordsets |
How to use arrays
with a DAO recordset. |
| Using DAO Bookmarks |
How to use DAO
Bookmarks. |
| |
|
ADO & DAO
|
| RecordCount |
Using the
RecordCount property with ADO & DAO recordsets. |
| Testing for an empty Recordset |
How to test for
empty ADO & DAO recordsets. |
| AbsolutePosition &
AbsolutePercent |
Using the
AbsolutePosition & AbsolutePercent properties of ADO & DAO recordsets.
|
| Deleting rows |
How to delete data
rows in ADO & DAO recordsets. |
| Using MoveNext and
MovePrevious |
Navigating ADO & DAO
recordsets using MovePrevious & MoveNext. |
| Adding a row to an ADO & DAO
Recordset |
How to add rows to
an ADO & DAO a recordset. |
| |
|
| |
|