Previous Topic Next topic Print topic


ADO.NET Cursor Statements

ADO.NET cursor statements enable you to define, create and manipulate an ADO.NET DataRows cursor. These statements are similar to SQL cursor statements. However, instead of a selection criteria based on a table in a data source, an ADO.NET DataRows cursor is based on a DataTable in a DataSet.

The following ADO.NET cursor statements are available to you:
DECLARE DATAROWS
Defines a DataRows cursor.
OPEN
Creates and opens a DataRows cursor.
FETCH
Fetches the DataRows from the DataRows cursor.
DELETE (POSITIONED)
Deletes the current DataRow from the DataRows cursor.
UPDATE (POSITIONED)
Updates the current DataRow in the DataRows cursor.
LOAD DATATABLE
Populates an ADO DataTable. This enables you to populate DataTables using both static and dynamic queries. Operations can be applied to DataTables that are contained within a dataset or DataTables that are standalone.
CLOSE
Closes a DataRows cursor.
Previous Topic Next topic Print topic