Application development with .NET - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 271

ExecuteNonQuery : Use this to execute a SQL command that does not
return any data, such as UPDATE, INSERT, or DELETE SQL operations.
Method returns the number of rows affected for given execution, as shown:
int rowsAffected = cmd.ExecuteNonQuery();
ExecuteReader : Use this to execute a SQL query that returns a DataReader.
DataReader is fast forward-only stream of data, for example:
DB2DataReader reader = cmd.ExecuteReader ( );
ExecuteScalar : Use this to execute a SQL command that retrieve a single
value from a database, for example:
int count=(int)cmd.ExecuteScalar();
Note: Object returned by cmd.ExecuteScalar() should be casted to data
type of underlying database object. The above example is valid for a case
where a single value being retrieved is from int column.
DataAdapter
The data adapter object populates a disconnected DataSet with data and
performs update. It contains the four optional commands for the select, insert,
update, and delete. Use it between DataSet and database for loading and
unloading data.
Implement this as DB2DataAdapter in DB2 .NET Data Provider, for example:
DB2DataAdapter adapter = new DB2DataAdapter();
Implement this as OleDbDataAdapter in DB2 OLE DB Data Provider, for
example:
OleDbDataAdapter adapter = new OleDbDataAdapter();
Implement this as OdbcDataAdapter in DB2 ODBC Data Provider, for
example:
OdbcDataAdapter adapter = new OdbcDataAdapter();
Data adapter object has these public properties:
DeleteCommand
InsertCommand
SelectCommand
UpdateCommand
The DeleteCommand deletes records using SQL statements or stored
procedures from the data set, for example:
adapter.DeleteCommand = new DB2Command(“DELETE From org WHERE DEPTNUMB
= 10”, connection);