PsqlDataAdapter Object
Show this topic in Library frames
The PsqlDataAdapter object uses PsqlCommand objects to execute SQL commands on the Pervasive.SQL database, to load the DataSet with data, and to reconcile the changed data in the DataSet to the database.
Table 4-7 describes the public properties of PsqlDataAdapter.
Table 4-7 Public Properties of the PsqlDataAdapter Object
|
Property
|
Description
|
|
DeleteCommand
|
Gets or sets a SQL statement for deleting records from the Pervasive.SQL data source.
|
|
InsertCommand
|
Gets or sets a SQL statement used to insert new records into the Pervasive.SQL database.
|
|
MissingMappingAction
|
Determines the action to take when incoming data does not have a matching table or column.
|
|
MissingSchemaAction
|
Indicates or specifies whether missing source tables, columns, and their relationships are added to the data set schema, ignored, or cause an error to be raised.
|
|
SelectCommand
|
Gets or sets a SQL statement used to select records in the Pervasive.SQL database.
|
|
TableMappings
|
Gets a collection that provides the master mapping between a source table and a DataTable.
|
|
UpdateCommand
|
Gets or sets a SQL statement used to update records in the data source.
|
Table 4-8 describes the public methods of the PsqlDataAdapter.
Table 4-8 Public Methods of the PsqlDataAdapter Object
|
Method
|
Description
|
|
Fill
|
Adds or refreshes rows in the DataSet to match those in the data source, and creates a DataTable named Table.
|
|
FillSchema
|
Adds a DataTable named Table to a DataSet and configures the schema to match that in the data source.
|
|
GetFillParameters
|
Gets the parameters set by the user when executing a SQL SELECT statement.
|
|
Update
|
Calls the INSERT, UPDATE, or DELETE SQL statements for each inserted, updated, or deleted row in the DataSet.
|
