IfxCommandBuilder class

The IfxCommandBuilder class automatically generates single-table INSERT, DELETE, and UPDATE commands that are used to reconcile changes made in a data set with the associated instance of the HCL OneDB™ database. An IfxCommandBuilder object is always associated with an IfxDataAdapter object (in a one-to-one relationship). The IfxDataAdapter object uses IfxCommand objects to execute SQL commands against the database, fill data sets, and reconcile changes in the data set with the database. Automatic generation of SQL statements for data reconciliation is initiated when you set the SelectCommand property of the IfxDataAdapter object. The SelectCommand property gets or sets an SQL SELECT statement to be run against the database. Then, when you create an IfxCommandBuilder object, it automatically generates SQL statements for single-table updates to reconcile changes in the data set with the database. (The IfxCommandBuilder object registers itself as a listener for RowUpdating events of the IfxDataAdapter object.)

For more information about using IfxCommandBuilder objects, see Reconcile DataSet changes with the database.