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.
