See Also

MySqlDataAdapter Class  | Devart.Data.MySql Namespace  | MySqlConnection Class  | MySqlCommand Class

See AlsoDevart.Data.MySqlSend comments on this topic.

MySqlDataAdapter Class Members

Devart.Data.MySql Namespace : MySqlDataAdapter Class

MySqlDataAdapter overview

Public Constructors

Public Constructor MySqlDataAdapter ConstructorOverloaded. Initializes a new instance of the MySqlDataAdapter class.

Public Properties

Public Property AcceptChangesDuringFill (Inherited from System.Data.Common.DataAdapter)Gets or sets a value indicating whether AcceptChanges is called on a DataRow after it is added to the DataTable during any of the Fill operations.
Public Property AcceptChangesDuringUpdate (Inherited from System.Data.Common.DataAdapter)Gets or sets whether AcceptChanges is called during a Update.
Public Property Container (Inherited from System.ComponentModel.Component)Gets the IContainer that contains the Component.
Public Property ContinueUpdateOnError (Inherited from System.Data.Common.DataAdapter)Gets or sets a value that specifies whether to generate an exception when an error is encountered during a row update.
Public Property DeleteCommandGets or sets a MySQL statement to delete records from the data set.
Public Property FillLoadOption (Inherited from System.Data.Common.DataAdapter)Gets or sets the LoadOption that determines how the adapter fills the DataTable from the DbDataReader.
Public Property InsertCommandGets or sets a MySQL statement to insert new records into the data source.
Public Property MissingMappingAction (Inherited from System.Data.Common.DataAdapter)Determines the action to take when incoming data does not have a matching table or column.
Public Property MissingSchemaAction (Inherited from System.Data.Common.DataAdapter)Determines the action to take when existing DataSet schema does not match incoming data.
Public Propertystatic (Shared in Visual Basic) RetrieveAutoIncrementSeedGets or sets a value that indicates whether MySqlDataAdapter should perform additional roundtrip to server to request the autoincremented value.
Public Property ReturnProviderSpecificTypes (Inherited from System.Data.Common.DataAdapter)Gets or sets whether the Fill method should return provider-specific values or common CLS-compliant values.
Public Property SelectCommandGets or sets a MySQL statement used to select records in the data source.
Public Property Site (Inherited from System.ComponentModel.Component)Gets or sets the ISite of the Component.
Public Property TableMappingsGets a collection that provides the master mapping between a source table and a MySqlDataTable.
Public Property UpdateBatchSizeOverridden. Gets or sets the number of rows that are processed in each round-trip to the server.
Public Property UpdateCommandGets or sets a MySQL statement used to update records in the data source.

Public Methods

Public Method CreateObjRef (Inherited from System.MarshalByRefObject)Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Public Method Dispose (Inherited from System.ComponentModel.Component)Releases all resources used by the Component.
Public Method Fill (Inherited from System.Data.Common.DbDataAdapter)Overloaded. Adds or refreshes rows in the DataSet.
Public Method FillPage (Inherited from Devart.Common.DbDataAdapter)Fills associated DataSet with specified range of rows.
Public Method FillSchema (Inherited from System.Data.Common.DbDataAdapter)Overloaded. Configures the schema of the specified DataTable based on the specified SchemaType.
Public Method GetFillParameters (Inherited from System.Data.Common.DbDataAdapter)Gets the parameters set by the user when executing an SQL SELECT statement.
Public Method GetLifetimeService (Inherited from System.MarshalByRefObject)Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Public Method InitializeLifetimeService (Inherited from System.MarshalByRefObject)Obtains a lifetime service object to control the lifetime policy for this instance.
Public Method ResetFillLoadOption (Inherited from System.Data.Common.DataAdapter)Resets FillLoadOption to its default state and causes Fill to honor AcceptChangesDuringFill.
Public Method ShouldSerializeAcceptChangesDuringFill (Inherited from System.Data.Common.DataAdapter)Determines whether the AcceptChangesDuringFill property should be persisted.
Public Method ShouldSerializeFillLoadOption (Inherited from System.Data.Common.DataAdapter)Determines whether the FillLoadOption property should be persisted.
Public Method ToString (Inherited from System.ComponentModel.Component)Returns a String containing the name of the Component, if any. This method should not be overridden.
Public Method Update (Inherited from System.Data.Common.DbDataAdapter)Overloaded. Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified DataSet.

Public Events

Public Event Disposed (Inherited from System.ComponentModel.Component)Occurs when the component is disposed by a call to the Dispose method.
Public Event FillError (Inherited from System.Data.Common.DataAdapter)Returned when an error occurs during a fill operation.
Public Event RowUpdatedOccurs during Update after a command is executed against the data source. The attempt to update is made, so the event fires.
Public Event RowUpdatingOccurs during Update before a command is executed against the data source. The attempt to update is made, so the event fires.

See Also

MySqlDataAdapter Class  | Devart.Data.MySql Namespace  | MySqlConnection Class  | MySqlCommand Class

 

 


© 2002 - 2012 Devart. All Rights Reserved.