Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - .NET Programming » UltraLite .NET 2.0 API Reference » ULDataAdapter class

 

ULDataAdapter members

Public constructors
Member name Description

ULDataAdapter constructors

Initializes a new instance of the ULDataAdapter class.

Public properties
Member name Description

[external link] AcceptChangesDuringFill (inherited from DataAdapter)

Gets or sets a value indicating whether [external link] DataRow.AcceptChanges is called on a [external link] DataRow after it is added to the [external link] DataTable during any of the Fill operations.

[external link] AcceptChangesDuringUpdate (inherited from DataAdapter)

Gets or sets whether [external link] DataRow.AcceptChanges is called during a [external link] DataAdapter.Update.

[external link] ContinueUpdateOnError (inherited from DataAdapter)

Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.

DeleteCommand property

Specifies a ULCommand object that is executed against the database when DbDataAdapter.Update(System.Data.DataSet) is called to delete rows in the database that correspond to deleted rows in the System.Data.DataSet.

[external link] FillLoadOption (inherited from DataAdapter)

Gets or sets the [external link] LoadOption that determines how the adapter fills the [external link] DataTable from the [external link] DbDataReader.

InsertCommand property

Specifies a ULCommand object that is executed against the database when DbDataAdapter.Update(System.Data.DataSet) is called to insert rows in the database that correspond to inserted rows in the System.Data.DataSet.

[external link] MissingMappingAction (inherited from DataAdapter)

Determines the action to take when incoming data does not have a matching table or column.

[external link] MissingSchemaAction (inherited from DataAdapter)

Determines the action to take when existing [external link] DataSet schema does not match incoming data.

[external link] ReturnProviderSpecificTypes (inherited from DataAdapter)

Gets or sets whether the [external link] DataAdapter.Fill should return provider-specific values or common CLS-compliant values.

SelectCommand property

Specifies a ULCommand that is used during System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet) or System.Data.Common.DbDataAdapter.FillSchema(System.Data.DataSet,System.Data.SchemaType) to obtain a result set from the database for copying into a System.Data.DataSet.

TableMappings property

Returns a collection that provides the master mapping between a source table and a System.Data.DataTable

[external link] UpdateBatchSize (inherited from DbDataAdapter)

Gets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.

UpdateCommand property

Specifies a ULCommand object that is executed against the database when System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) is called to update rows in the database that correspond to updated rows in the System.Data.DataSet.

Public methods
Member name Description

[external link] Fill (inherited from DbDataAdapter)

Fills a [external link] DataSet or a [external link]  DataTable.

[external link] FillSchema (inherited from DbDataAdapter)

Adds a [external link] DataTable to a [external link] DataSet and configures the schema to match that in the data source.

GetFillParameters method

Returns the parameters set by the user when executing a SELECT statement.

[external link] ResetFillLoadOption (inherited from DataAdapter)

Resets [external link] DataAdapter.FillLoadOption to its default state and causes [external link] DataAdapter.Fill to honor [external link] DataAdapter.AcceptChangesDuringFill.

[external link] ShouldSerializeAcceptChangesDuringFill (inherited from DataAdapter)

Determines whether the [external link] DataAdapter.AcceptChangesDuringFill should be persisted.

[external link] ShouldSerializeFillLoadOption (inherited from DataAdapter)

Determines whether the [external link] DataAdapter.FillLoadOption should be persisted.

[external link] Update (inherited from DbDataAdapter)

Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the [external link] DataSet.

Public events
Member name Description

[external link] FillError (inherited from DataAdapter)

Returned when an error occurs during a fill operation.

RowUpdated event

Occurs during an update after a command is executed against the data source. When an attempt to update is made, the event fires.

RowUpdating event

Occurs during an update before a command is executed against the data source. When an attempt to update is made, the event fires.

See also