1.1

• SQLFRowUpdatingEventHandler on page 678
• SQLFRowUpdatingEventArgs on page 678
• SQLFRowUpdatedEventHandler on page 678
• SQLFRowUpdatedEventArgs on page 678
• Example on page 678
SQLFRowUpdatingEventHandler
This is the type of the RowUpdating event of the SQLFDataAdapter that is raised before an update is executed
against the data source.
SQLFRowUpdatingEventArgs
Concrete implementation of the System.Data.Common.RowUpdatingEventArgs base abstract class.
SQLFRowUpdatedEventHandler
This is the type of the RowUpdated event of the SQLFDataAdapter that is raised after an update has been executed
against the data source.
SQLFRowUpdatedEventArgs
Concrete implementation of the System.Data.Common.RowUpdatedEventArgs base abstract class.
The MSDN documentation for IDbDataAdapter and DbDataAdapter provides information about other API
methods and usage.
Example
// Open a new connection to the network server running on localhost:1527
string host = "localhost";
int port = 1527;
string connectionStr = string.Format("server={0}:{1}", host, port);
// use the SQLFire specific class for connection creation
using (SQLFClientConnection conn = new SQLFClientConnection(connectionStr))
{
conn.Open();
// create a table
// using the base DbCommand class rather than SQLFire specific class
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = "create table t1 (id int primary key, addr varchar(20))";
cmd.ExecuteNonQuery();
// populate DataTable from the underlying table
cmd = conn.CreateCommand();
cmd.CommandText = "select * from t1";
DbDataAdapter adapter = new SQLFDataAdapter((SQLFCommand)cmd);
adapter.SelectCommand = cmd;
// associate a command builder with the DataAdapter
DbCommandBuilder builder = new
SQLFCommandBuilder((SQLFDataAdapter)adapter);
// fill a DataTable using the above select SQL command
// though there is no data to be populated yet, the schema will still be
// set correctly in the DataTable even with no data which is required
// before trying to make any updates
vFabric SQLFire User's Guide678
vFabric SQLFire Reference