dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDataTable Class
Properties Methods Events

In This Topic
    MySqlDataTable Class Members
    In This Topic

    The following tables list the members exposed by MySqlDataTable.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the MySqlDataTable class.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets whether a Devart.Common.DbDataTable is filled with data from a data source. (Inherited from Devart.Common.DbDataTable)
    Public PropertyEnables or disables cached updates mode. (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets the collection of columns that belong to this table. (Inherited from Devart.Common.DbDataTable)
    Public PropertySpecifies which System.Data.ConflictOption is to be used by the Devart.Common.DbDataTable. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets the MySqlConnection used to connect to the data source.  
    Public PropertyGets the collection of constraints maintained by this table. (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public Property (Inherited from System.Data.DataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets or sets a MySQL statement to delete records from the data set.  
    Public Property (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public Property (Inherited from System.Data.DataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyOverridden. Determines whether data is requested from server entirely or partially.  
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets or sets a MySQL statement to insert new records into the data source.  
    Public Property (Inherited from System.Data.DataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets or sets max number of records to fetch starting from StartRecord. (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyDetermines the action to take when existing DataSet schema does not match incoming data. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets name of the component. (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets or sets data request mode. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets form that the component resides on. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets a Devart.Common.ParentDataRelation object that is used for server side master-detail relation. (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets or sets an array of columns that function as primary keys for the data table. (Inherited from Devart.Common.DbDataTable)
    Public PropertyDetermines whether Devart.Common.DbDataTable should perfrom additional request to determine quantity of records in the result set. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets whether the Devart.Common.DbDataTable quotes all the names of data source objects. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets number of rows in the result set. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets list of fields whose values should be retrieved after a DML statement execution.  
    Public PropertyGets or sets a value that indicates whether and how the Devart.Common.DbDataTable should retrieve field values adjusted by server after an update. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets a System.Data.SerializationFormat for the Devart.Common.DbDataTable used during remoting. (Inherited from Devart.Common.DbDataTable)
    Public PropertyDetermines whether to use provider-specific types whenever possible. (Inherited from Devart.Common.DbDataTable)
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets the schema table corresponding to the SelectCommand query. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets a MySQL statement used to select records in the data source.  
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets or sets record number to start. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets an object that can be used to synchronize access to the System.Data.DataTable.Rows collection. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets a System.Data.Common.DataTableMapping object that provides the master mapping between a source table and a MySqlDataTable.  
    Public Property (Inherited from System.Data.DataTable)
    Public PropertyGets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch. (Inherited from Devart.Common.DbDataTable)
    Public PropertyGets or sets a MySQL statement used to update records in the data source.  
    Public PropertyGets or sets string containing list of field names used to generate update commands.  
    Public PropertyGets or sets string containing list of key field names separated by semicolon. They are used to generate update commands.  
    Public PropertyGets or sets table name to generate update statements for.  
    Top
    Public Methods
     NameDescription
    Public Method (Inherited from System.Data.DataTable)
    Public MethodStarts an asynchronous invocation of the Fill() method. (Inherited from Devart.Common.DbDataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public MethodStops asynchronous fill operation. (Inherited from Devart.Common.DbDataTable)
    Public MethodClears Devart.Common.DbDataTable and stops Fill operation. (Inherited from Devart.Common.DbDataTable)
    Public MethodClones the structure of the Devart.Common.DbDataTable, including all System.Data.DataTable schemes and constraints. (Inherited from Devart.Common.DbDataTable)
    Public MethodDisconnects Devart.Common.DbDataTable from the data source and frees server resources allocated for the query. (Inherited from Devart.Common.DbDataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodEnds an asynchronous invocation of the Fill() method. (Inherited from Devart.Common.DbDataTable)
    Public MethodEnds the initialization of a Devart.Common.DbDataTable that is used on a form or used by another component. The initialization occurs at run time. (Inherited from Devart.Common.DbDataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Fills the System.Data.DataTable.Rows collection of the Devart.Common.DbDataTable with rows from the data source using the parameter values passed in parameterValues. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded. Overridden. Fills the System.Data.DataTable.Rows collection of the Devart.Common.DbDataTable with rows from the data source starting at the row indicated by startRecord and including up to the number of rows indicated by maxRecords.  
    Public MethodConfigures the schema to match that in the data source. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public Method (Inherited from System.Data.DataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public MethodFetches data and sets the Active property to true. (Inherited from Devart.Common.DbDataTable)
    Public MethodReads the next data row when Devart.Common.DbDataTable operates in connected model. (Inherited from Devart.Common.DbDataTable)
    Public MethodFills a row with data not fetched in the initial fill operation. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodRefreshes the specified row with values from server. (Inherited from Devart.Common.DbDataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Gets an array of all DataRow objects. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded. Suspends asynchronous fill operation. (Inherited from Devart.Common.DbDataTable)
    Public Method (Inherited from System.Data.DataTable)
    Public MethodExecutes the appropriate commands to delete, insert, or update rows in the data source. (Inherited from Devart.Common.DbDataTable)
    Public MethodExecutes the appropriate commands to delete, insert, or update the specified rows in the data source. (Inherited from Devart.Common.DbDataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodOverloaded.  (Inherited from System.Data.DataTable)
    Top
    Public Events
     NameDescription
    Public Event (Inherited from System.Data.DataTable)
    Public Event (Inherited from System.Data.DataTable)
    Public EventAdds an event handler to listen to the Disposed event on the component. (Inherited from Devart.Common.DbDataTable)
    Public EventOccurs when a result set is completely fetched. (Inherited from Devart.Common.DbDataTable)
    Public EventOccurs when an error is raised during a fill operation. (Inherited from Devart.Common.DbDataTable)
    Public Event (Inherited from System.Data.DataTable)
    Public Event (Inherited from System.Data.DataTable)
    Public Event (Inherited from System.Data.DataTable)
    Public Event (Inherited from System.Data.DataTable)
    Public Event (Inherited from System.Data.DataTable)
    Public EventOccurs when another row is completely fetched. (Inherited from Devart.Common.DbDataTable)
    Public EventOccurs during System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) after a command is executed against the data source. The attempt to update is made, so the event fires.  
    Public EventOccurs during System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) before a command is executed against the data source. The attempt to update is made, so the event fires.  
    Public Event (Inherited from System.Data.DataTable)
    Public Event (Inherited from System.Data.DataTable)
    Public Event (Inherited from System.Data.DataTable)
    Top
    See Also