Represents a set of commands and a database connection used to fill a System.Data.DataSet and to update a database.
Public NotInheritable Class ULDataAdapter Inherits System.Data.Common.DbDataAdapter Implements System.ICloneable
public sealed class ULDataAdapter : System.Data.Common.DbDataAdapter, System.ICloneable
All members of ULDataAdapter class, including all inherited members.
Name | Description |
---|---|
Initializes a ULDataAdapter object. | |
AddToBatch method (Inherited from System.Data.Common.DbDataAdapter) |
Adds a System.Data.IDbCommand to the current batch. |
ClearBatch method (Inherited from System.Data.Common.DbDataAdapter) |
Removes all System.Data.IDbCommand objects from the batch. |
CreateRowUpdatedEvent method (Inherited from System.Data.Common.DbDataAdapter) |
Initializes a new instance of the System.Data.Common.RowUpdatedEventArgs class. |
CreateRowUpdatingEvent method (Inherited from System.Data.Common.DbDataAdapter) |
Initializes a new instance of the System.Data.Common.RowUpdatingEventArgs class. |
Dispose method (Inherited from System.Data.Common.DbDataAdapter) |
Releases the unmanaged resources used by the System.Data.Common.DbDataAdapter and optionally releases the managed resources. |
ExecuteBatch method (Inherited from System.Data.Common.DbDataAdapter) |
Executes the current batch. |
Fill method (Inherited from System.Data.Common.DbDataAdapter) |
Adds or refreshes rows in the System.Data.DataSet. |
FillSchema method (Inherited from System.Data.Common.DbDataAdapter) |
Adds a System.Data.DataTable named "Table" to the specified System.Data.DataSet and configures the schema to match that in the data source based on the specified System.Data.SchemaType. |
GetBatchedParameter method (Inherited from System.Data.Common.DbDataAdapter) |
Returns a System.Data.IDataParameter from one of the commands in the current batch. |
GetBatchedRecordsAffected method (Inherited from System.Data.Common.DbDataAdapter) |
Returns information about an individual update attempt within a larger batched update. |
Returns the parameters set by the user when executing a SELECT statement. | |
InitializeBatching method (Inherited from System.Data.Common.DbDataAdapter) |
Initializes batching for the System.Data.Common.DbDataAdapter. |
FillError (Inherited from System.Data.Common.DbDataAdapter) OnFillError method (Inherited from System.Data.Common.DbDataAdapter) |
|
OnRowUpdated method (Inherited from System.Data.Common.DbDataAdapter) |
Raises the RowUpdated event of a .NET Framework data provider. |
OnRowUpdating method (Inherited from System.Data.Common.DbDataAdapter) |
Raises the RowUpdating event of a .NET Framework data provider. |
TerminateBatching method (Inherited from System.Data.Common.DbDataAdapter) |
Ends batching for the System.Data.Common.DbDataAdapter. |
Update method (Inherited from System.Data.Common.DbDataAdapter) |
Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of System.Data.DataRow objects. |
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. | |
FillCommandBehavior property (Inherited from System.Data.Common.DbDataAdapter) |
Gets or sets the behavior of the command used to fill the data adapter. |
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. | |
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. | |
Returns a collection that provides the master mapping between a source table and a System.Data.DataTable | |
UpdateBatchSize property (Inherited from System.Data.Common.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. |
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. | |
Occurs during an update after a command is executed against the data source. | |
Occurs during an update before a command is executed against the data source. | |
DefaultSourceTableName field (Inherited from System.Data.Common.DbDataAdapter) |
The default name used by the System.Data.Common.DataAdapter object for table mappings. |
The System.Data.DataSet provides a way to work with data offline; that is, away from your UltraLite database. The ULDataAdapter provides methods to associate a System.Data.DataSet with a set of SQL statements.
Since UltraLite is a local database and MobiLink has conflict resolution, the use of the ULDataAdapter is limited. For most purposes, the ULDataReader or the ULTable provide more efficient access to data.
ULDataAdapter constructor
GetFillParameters method
DeleteCommand property
InsertCommand property
SelectCommand property
TableMappings property
UpdateCommand property
RowUpdated event
RowUpdating event
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |