Working with recordsets

Extensibility > Using External Databases > Using Structured Query Language > Working with Recordsets

ADO.NET uses disconnected recordsets to view data from a database. These are created by the function SQLGetRecordset. A handle to the created recordset is returned and can be used in subsequent functions.

To access data from a specified column and row, use the SQLGetField function with a recordset handle. Null detection can be performed by using the SQLIsNullField function. See the code example in the SQLCreate function for a simple example.

ADO.NET allows you to create many queries per single database connection object. Queries are created using the SQLQueryCreate function and disposed by the SQLQueryDispose function.