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
• CLOSE – closes a DataRows cursor