Types of Recordsets in Visual Basic

A resultset  returned from a database server as a result of the execution of an SQL statement can be stored in a Recordset object for further manipulation. In other words, a Recordset object can manipulate data returned by a provider. All Recordset objects consists of records (rows) and fields (columns).

There are 4 types of  recordsets

Dynamic recordsets

A dynamic recordset allows viewing  the result of additions, changes and deletion by other users. It allows all types of movements on a Recordset, such as scrolling through the Records in the forward and reverse direction.

Keyset recordsets

The Keyset recordset is same as Dynamic recordset but prevents seeing of changes by the other users.

Static Recordset

Provides the static copy of a set of records  to find data or generate reports. Allows Scrolling through the recordset. Additions, changes or deletions by other users are not visible.

Forward only Recordset

Behaves  identical  to a static Recordset  and allows forward only scrolling. This improves performance in situations where you need to make a single pass through a recordset. We can create any of the above types of recordsets by setting the required value in the Cursor type property of the recordset object after initializing the recordset object