MySqlDataAdapter Methods

MySQL Connector/Net

previous page next page
MySqlDataAdapter Methods

The MySqlDataAdapter type exposes the following members.

Methods
  Name Description
Protected method AddToBatch (Overrides DbDataAdapterAddToBatch(IDbCommand).)
Protected method ClearBatch (Overrides DbDataAdapterClearBatch.)
Protected method CloneInternals Obsolete.
Creates a copy of this instance of DataAdapter.
(Inherited from DataAdapter.)
Public method CreateObjRef
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from MarshalByRefObject.)
Protected method CreateRowUpdatedEvent
Overridden. See CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping).
(Overrides DbDataAdapterCreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping).)
Protected method CreateRowUpdatingEvent
Overridden. See CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping).
(Overrides DbDataAdapterCreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping).)
Protected method CreateTableMappings
Creates a new DataTableMappingCollection.
(Inherited from DataAdapter.)
Public method Dispose
Releases all resources used by the Component.
(Inherited from Component.)
Protected method Dispose(Boolean)
Releases the unmanaged resources used by the DbDataAdapter and optionally releases the managed resources.
(Inherited from DbDataAdapter.)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Protected method ExecuteBatch (Overrides DbDataAdapterExecuteBatch.)
Public method Fill(DataSet)
Adds or refreshes rows in the DataSet.
(Inherited from DbDataAdapter.)
Public method Fill(DataTable)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataTable name.
(Inherited from DbDataAdapter.)
Public method Fill(DataSet, String)
Adds or refreshes rows in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Protected method Fill(DataTable, IDataReader)
Adds or refreshes rows in the DataTable to match those in the data source using the DataTable name and the specified IDataReader.
(Inherited from DataAdapter.)
Public method Fill(Int32, Int32, DataTable)
Adds or refreshes rows in a DataTable to match those in the data source starting at the specified record and retrieving up to the specified maximum number of records.
(Inherited from DbDataAdapter.)
Protected method Fill(DataTable, IDbCommand, CommandBehavior)
Adds or refreshes rows in a DataTable to match those in the data source using the specified DataTable, IDbCommand and CommandBehavior.
(Inherited from DbDataAdapter.)
Public method Fill(DataSet, Int32, Int32, String)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Protected method Fill(DataTable, IDataReader, Int32, Int32)
Adds or refreshes rows in a specified range in the collection of DataTable objects to match those in the data source.
(Inherited from DataAdapter.)
Protected method Fill(DataTable, Int32, Int32, IDbCommand, CommandBehavior)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DbDataAdapter.)
Protected method Fill(DataSet, String, IDataReader, Int32, Int32)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.
(Inherited from DataAdapter.)
Protected method Fill(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior)
Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and source table names, command string, and command behavior.
(Inherited from DbDataAdapter.)
Public method FillAsync(DataSet)
Async version of Fill
Public method FillAsync(DataTable)
Async version of Fill
Public method FillAsync(DataSet, String)
Async version of Fill
Public method FillAsync(DataSet, CancellationToken)
Public method FillAsync(DataTable, IDataReader)
Async version of Fill
Public method FillAsync(DataTable, CancellationToken)
Public method FillAsync(DataSet, String, CancellationToken)
Public method FillAsync(DataTable, IDataReader, CancellationToken)
Public method FillAsync(DataTable, IDbCommand, CommandBehavior)
Async version of Fill
Public method FillAsync(Int32, Int32, DataTable)
Async version of Fill
Public method FillAsync(DataSet, Int32, Int32, String)
Async version of Fill
Public method FillAsync(DataTable, IDbCommand, CommandBehavior, CancellationToken)
Public method FillAsync(Int32, Int32, CancellationToken, DataTable)
Public method FillAsync(DataSet, Int32, Int32, String, CancellationToken)
Public method FillAsync(DataSet, String, IDataReader, Int32, Int32)
Async version of Fill
Public method FillAsync(DataTable, Int32, Int32, IDbCommand, CommandBehavior)
Async version of Fill
Public method FillAsync(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior)
Async version of Fill
Public method FillAsync(DataSet, String, IDataReader, Int32, Int32, CancellationToken)
Public method FillAsync(DataTable, Int32, Int32, IDbCommand, CommandBehavior, CancellationToken)
Public method FillAsync(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior, CancellationToken)
Public method FillSchema(DataTable, SchemaType)
Configures the schema of the specified DataTable based on the specified SchemaType.
(Inherited from DbDataAdapter.)
Public method FillSchema(DataSet, SchemaType)
Adds a DataTable named "Table" to the specified DataSet and configures the schema to match that in the data source based on the specified SchemaType.
(Inherited from DbDataAdapter.)
Public method FillSchema(DataSet, SchemaType, String)
Adds a DataTable to the specified DataSet and configures the schema to match that in the data source based upon the specified SchemaType and DataTable.
(Inherited from DbDataAdapter.)
Protected method FillSchema(DataTable, SchemaType, IDataReader)
Adds a DataTable to the specified DataSet.
(Inherited from DataAdapter.)
Protected method FillSchema(DataTable, SchemaType, IDbCommand, CommandBehavior)
Configures the schema of the specified DataTable based on the specified SchemaType, command string, and CommandBehavior values.
(Inherited from DbDataAdapter.)
Protected method FillSchema(DataSet, SchemaType, String, IDataReader)
Adds a DataTable to the specified DataSet.
(Inherited from DataAdapter.)
Protected method FillSchema(DataSet, SchemaType, IDbCommand, String, CommandBehavior)
Adds a DataTable to the specified DataSet and configures the schema to match that in the data source based on the specified SchemaType.
(Inherited from DbDataAdapter.)
Public method FillSchemaAsync(DataSet, SchemaType)
Async version of FillSchema
Public method FillSchemaAsync(DataTable, SchemaType)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, String)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, CancellationToken)
Public method FillSchemaAsync(DataTable, SchemaType, IDataReader)
Async version of FillSchema
Public method FillSchemaAsync(DataTable, SchemaType, CancellationToken)
Public method FillSchemaAsync(DataSet, SchemaType, String, IDataReader)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, String, CancellationToken)
Public method FillSchemaAsync(DataTable, SchemaType, IDataReader, CancellationToken)
Public method FillSchemaAsync(DataTable, SchemaType, IDbCommand, CommandBehavior)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, IDbCommand, String, CommandBehavior)
Async version of FillSchema
Public method FillSchemaAsync(DataSet, SchemaType, String, IDataReader, CancellationToken)
Public method FillSchemaAsync(DataTable, SchemaType, IDbCommand, CommandBehavior, CancellationToken)
Public method FillSchemaAsync(DataSet, SchemaType, IDbCommand, String, CommandBehavior, CancellationToken)
Protected method Finalize
Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.
(Inherited from Component.)
Protected method GetBatchedParameter (Overrides DbDataAdapterGetBatchedParameter(Int32, Int32).)
Protected method GetBatchedRecordsAffected
Returns information about an individual update attempt within a larger batched update.
(Inherited from DbDataAdapter.)
Public method GetFillParameters
Gets the parameters set by the user when executing an SQL SELECT statement.
(Inherited from DbDataAdapter.)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public method GetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method GetService
Returns an object that represents a service provided by the Component or by its Container.
(Inherited from Component.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected method HasTableMappings
Indicates whether a DataTableMappingCollection has been created.
(Inherited from DataAdapter.)
Protected method InitializeBatching (Overrides DbDataAdapterInitializeBatching.)
Public method InitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected method MemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
Protected method OnFillError
Invoked when an error occurs during a Fill.
(Inherited from DataAdapter.)
Protected method OnRowUpdated
Overridden. Raises the RowUpdated event.
(Overrides DbDataAdapterOnRowUpdated(RowUpdatedEventArgs).)
Protected method OnRowUpdating
Overridden. Raises the RowUpdating event.
(Overrides DbDataAdapterOnRowUpdating(RowUpdatingEventArgs).)
Public method ResetFillLoadOption
Resets FillLoadOption to its default state and causes Fill(DataSet) to honor AcceptChangesDuringFill.
(Inherited from DataAdapter.)
Public method ShouldSerializeAcceptChangesDuringFill
Determines whether the AcceptChangesDuringFill property should be persisted.
(Inherited from DataAdapter.)
Public method ShouldSerializeFillLoadOption
Determines whether the FillLoadOption property should be persisted.
(Inherited from DataAdapter.)
Protected method ShouldSerializeTableMappings
Determines whether one or more DataTableMapping objects exist and they should be persisted.
(Inherited from DataAdapter.)
Protected method TerminateBatching (Overrides DbDataAdapterTerminateBatching.)
Public method ToString
Returns a String containing the name of the Component, if any. This method should not be overridden.
(Inherited from Component.)
Public method Update(DataSet)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataSet.
(Inherited from DbDataAdapter.)
Public method Update(DataRow)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array in the DataSet.
(Inherited from DbDataAdapter.)
Public method Update(DataTable)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataTable.
(Inherited from DbDataAdapter.)
Public method Update(DataSet, String)
Updates the values in the database by executing the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet with the specified DataTable name.
(Inherited from DbDataAdapter.)
Protected method Update(DataRow, DataTableMapping) (Overrides DbDataAdapterUpdate(DataRow, DataTableMapping).)
Public method UpdateAsync(DataRow)
Async version of Update
Public method UpdateAsync(DataSet)
Async version of Update
Public method UpdateAsync(DataTable)
Async version of Update
Public method UpdateAsync(DataRow, DataTableMapping)
Async version of Update
Public method UpdateAsync(DataRow, CancellationToken)
Public method UpdateAsync(DataSet, String)
Async version of Update
Public method UpdateAsync(DataSet, CancellationToken)
Public method UpdateAsync(DataTable, CancellationToken)
Public method UpdateAsync(DataRow, DataTableMapping, CancellationToken)
Public method UpdateAsync(DataSet, String, CancellationToken)
Top
See Also
previous page start next page