Data Table Support in ADO.NET

OpenESQL supports two types of data tables in ADO.NET - data tables inside data sets, and free-standing data tables. The EXEC ADO operations available for each type differ in the way data tables are specified in their syntax. For example, EXEC ADO statements that apply to free-standing data tables contain a DATATABLE keyword in their syntax. Those that apply to data tables within data sets contain an optional USING clause.

EXEC ADO statements that support free-standing data tables

  • DECLARE DATATABLE
  • GET CURSOR
  • GET DATATABLE
  • INITIALIZE DATATABLE
  • LOAD DATATABLE
  • MERGE
  • SAVE DATATABLE
  • UNBIND

EXEC ADO statements that support data tables within data sets

  • ACCEPT CHANGES
  • BIND
  • CLEAR
  • DECLARE DATAROWS
  • DELETE (POSITIONED)
  • DELETE (SEARCHED)
  • GET CHANGES
  • GET DATATABLE
  • INITIALIZE DATASET
  • INSERT
  • LOAD DATASET
  • LOAD DATATABLE
  • MERGE
  • PREPARE TO FILL
  • PREPARE TO UPDATE
  • REJECT CHANGES
  • SAVE DATASET
  • SAVE DATATABLE
  • SELECT INTO
  • TO DELETE USE
  • TO FILL USE
  • TO INSERT USE
  • TO REFRESH USE
  • TO UPDATE USE
  • UNBIND
  • UPDATE (POSITIONED)
  • UPDATE (SEARCHED)

See the Embedded ADO Statements reference section for details on each statement.