RecordSet
Set of records coming from table or the result of a command. Always, a Recordset object refers to only a single record. Recordset objects consist of records (rows) and fields (columns). Depending on the functionality supported by the provider.
Cursor types
- Dynamic cursor Add, Change, and Delete operations performed by other users can be tracked.
- Keyset cursor Similar to dynamic cursor, except that it prevents you from seeing records that other users add.
- Static cursor Offers a static copy of a set of records which cannot be amended or changed once pulled.
- Forward-only cursor Allows you to only scroll forward through the Recordset. Add, Change, or delete operations performed by other users will not be visible.
Updates
- Immediate: In immediate updating, all changes to data are written immediately to the underlying data source once you call the Update method.
- Batch: The records pushed to the database by blocking a session in bulk. Once all records are successfully written in the database commit will happen.
Next >> Various database connections to connect a Excel File