dotConnect for SQL Server Documentation
Devart.Common Namespace / DbDataTable Class
Properties Methods Events

In This Topic
    DbDataTable Class Members
    In This Topic

    The following tables list the members exposed by DbDataTable.

    Public Properties
     NameDescription
    Public PropertyGets or sets whether a DbDataTable is filled with data from a data source.  
    Public PropertyEnables or disables cached updates mode.  
    Public Property  
    Public PropertyIndicates whether string comparisons within the table are case-sensitive. (Inherited from System.Data.DataTable)
    Public PropertyGets the collection of child relations for this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets the collection of columns that belong to this table.  
    Public PropertySpecifies which System.Data.ConflictOption is to be used by the DbDataTable.  
    Public PropertyGets or sets the System.Data.IDbConnection used to connect to the data source.  
    Public PropertyGets the collection of constraints maintained by this table.  
    Public PropertyGets the container for the component. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public PropertyGets the System.Data.DataSet to which this table belongs. (Inherited from System.Data.DataTable)
    Public PropertyGets a customized view of the table that may include a filtered view, or a cursor position. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets a SQL statement to delete records from the data set.  
    Public PropertyGets a value indicating whether the component is currently in design mode. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public Propertystatic (Shared in Visual Basic)Disables some of the events, which occurs when DbDataTable content is changed.  
    Public PropertyGets or sets the expression that returns a value used to represent this table in the user interface. The DisplayExpression property lets you display the name of this table in a user interface. (Inherited from System.Data.DataTable)
    Public PropertyGets the collection of customized user information. (Inherited from System.Data.DataTable)
    Public PropertyDetermines whether data is requested from server entirely or partially.  
    Public PropertyGets a value indicating whether there are errors in any of the rows in any of the tables of the System.Data.DataSet to which the table belongs. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets a SQL statement to insert new records into the data source.  
    Public PropertyGets a value that indicates whether the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets the locale information used to compare strings within the table. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets max number of records to fetch starting from StartRecord.  
    Public PropertyGets or sets the initial starting size for this table. (Inherited from System.Data.DataTable)
    Public PropertyDetermines the action to take when existing DataSet schema does not match incoming data.  
    Public PropertyGets or sets name of the component.  
    Public PropertyGets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets data request mode.  
    Public PropertyGets or sets form that the component resides on.  
    Public PropertyGets or sets a ParentDataRelation object that is used for server side master-detail relation.  
    Public PropertyGets the collection of parent relations for this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets an array of columns that function as primary keys for the data table.  
    Public PropertyDetermines whether DbDataTable should perfrom additional request to determine quantity of records in the result set.  
    Public PropertyGets or sets whether the DbDataTable quotes all the names of data source objects.  
    Public PropertyGets number of rows in the result set.  
    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 DbDataTable should retrieve field values adjusted by server after an update.  
    Public PropertyGets or sets a System.Data.SerializationFormat for the DbDataTable used during remoting.  
    Public PropertyDetermines whether to use provider-specific types whenever possible.  
    Public PropertyGets the collection of rows that belong to this table. (Inherited from System.Data.DataTable)
    Public PropertyGets the schema table corresponding to the SelectCommand query.  
    Public PropertyGets or sets a SQL statement used to select records in the data source.  
    Public PropertyGets or sets an System.ComponentModel.ISite for the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public PropertyGets or sets record number to start.  
    Public PropertyGets an object that can be used to synchronize access to the System.Data.DataTable.Rows collection.  
    Public PropertyGets a System.Data.Common.DataTableMapping that provides the master mapping between a source table and a DbDataTable.  
    Public PropertyGets or sets the name of the System.Data.DataTable. (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.  
    Public PropertyGets or sets a SQL 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 MethodCommits all the changes made to this table since the last time System.Data.DataTable.AcceptChanges was called. (Inherited from System.Data.DataTable)
    Public MethodStarts an asynchronous invocation of the Fill() method.  
    Public MethodBegins the initialization of a System.Data.DataTable that is used on a form or used by another component. The initialization occurs at run time. (Inherited from System.Data.DataTable)
    Public MethodTurns off notifications, index maintenance, and constraints while loading data. (Inherited from System.Data.DataTable)
    Public MethodStops asynchronous fill operation.  
    Public MethodClears DbDataTable and stops Fill operation.  
    Public MethodOverridden. Clones the structure of the DbDataTable, including all System.Data.DataTable schemes and constraints.  
    Public MethodDisconnects DbDataTable from the data source and frees server resources allocated for the query.  
    Public MethodComputes the given expression on the current rows that pass the filter criteria. (Inherited from System.Data.DataTable)
    Public MethodCopies both the structure and data for this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodReturns a System.Data.DataTableReader corresponding to the data within this System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodReleases all resources used by the System.ComponentModel.MarshalByValueComponent. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodEnds an asynchronous invocation of the Fill() method.  
    Public MethodOverridden. Ends the initialization of a DbDataTable that is used on a form or used by another component. The initialization occurs at run time.  
    Public MethodTurns on notifications, index maintenance, and constraints after loading data. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Fills the System.Data.DataTable.Rows collection of the DbDataTable with rows from the data source.  
    Public MethodOverloaded. Fills the System.Data.DataTable.Rows collection of the 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.  
    Public MethodOverloaded. Gets a copy of the System.Data.DataTable that contains all changes made to it since it was loaded or System.Data.DataTable.AcceptChanges was last called. (Inherited from System.Data.DataTable)
    Public MethodGets an array of System.Data.DataRow objects that contain errors. (Inherited from System.Data.DataTable)
    Public MethodPopulates a serialization information object with the data needed to serialize the System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodGets the implementer of the System.IServiceProvider. (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodCopies a System.Data.DataRow into a System.Data.DataTable, preserving any property settings, as well as original and current values. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Fills a System.Data.DataTable with values from a data source using the supplied System.Data.IDataReader. If the System.Data.DataTable already contains rows, the incoming data from the data source is merged with the existing rows. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Finds and updates a specific row. If no matching row is found, a new row is created using the given values. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Merge the specified System.Data.DataTable with the current System.Data.DataTable. (Inherited from System.Data.DataTable)
    Public MethodCreates a new System.Data.DataRow with the same schema as the table. (Inherited from System.Data.DataTable)
    Public MethodFetches data and sets the Active property to true.  
    Public MethodReads the next data row when DbDataTable operates in connected model.  
    Public MethodFills a row with data not fetched in the initial fill operation.  
    Public MethodOverloaded. Reads XML schema and data into the System.Data.DataTable using the specified System.IO.Stream. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Reads an XML schema into the System.Data.DataTable using the specified stream. (Inherited from System.Data.DataTable)
    Public MethodRefreshes the specified row with values from server.  
    Public MethodRolls back all changes that have been made to the table since it was loaded, or the last time System.Data.DataTable.AcceptChanges was called. (Inherited from System.Data.DataTable)
    Public MethodResets the System.Data.DataTable to its original state. Reset removes all data, indexes, relations, and columns of the table. If a DataSet includes a DataTable, the table will still be part of the DataSet after the table is reset. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Gets an array of DataRow objects.  
    Public MethodOverloaded. Suspends asynchronous fill operation.  
    Public MethodGets the System.Data.DataTable.TableName and System.Data.DataTable.DisplayExpression, if there is one as a concatenated string. (Inherited from System.Data.DataTable)
    Public MethodExecutes the appropriate commands to delete, insert, or update rows in the data source.  
    Public MethodExecutes the appropriate commands to delete, insert, or update the specified rows in the data source.  
    Public MethodOverloaded. Writes the current contents of the System.Data.DataTable as XML using the specified System.IO.Stream. (Inherited from System.Data.DataTable)
    Public MethodOverloaded. Writes the current data structure of the System.Data.DataTable as an XML schema to the specified stream. (Inherited from System.Data.DataTable)
    Top
    Public Events
     NameDescription
    Public EventOccurs after a value has been changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable)
    Public EventOccurs when a value is being changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable)
    Public EventAdds an event handler to listen to the Disposed event on the component.  
    Public EventOccurs when a result set is completely fetched.  
    Public EventOccurs when an error is raised during a fill operation.  
    Public EventOccurs after the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable)
    Public EventOccurs after a System.Data.DataRow has been changed successfully. (Inherited from System.Data.DataTable)
    Public EventOccurs when a System.Data.DataRow is changing. (Inherited from System.Data.DataTable)
    Public EventOccurs after a row in the table has been deleted. (Inherited from System.Data.DataTable)
    Public EventOccurs before a row in the table is about to be deleted. (Inherited from System.Data.DataTable)
    Public EventOccurs when another row is completely fetched.  
    Public EventOccurs after a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable)
    Public EventOccurs when a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable)
    Public EventOccurs when a new System.Data.DataRow is inserted. (Inherited from System.Data.DataTable)
    Top
    See Also