| Name | Description | |
|---|---|---|
 | Active | Gets or sets whether a DbDataTable is filled with data from a data source. |
| CachedUpdates | Enables or disables cached updates mode. |
| CancelEditRowIfUpdateFailed | |
| CaseSensitive | Indicates whether string comparisons within the table are case-sensitive. (Inherited from System.Data.DataTable) |
| ChildRelations | Gets the collection of child relations for this System.Data.DataTable. (Inherited from System.Data.DataTable) |
| Columns | Gets the collection of columns that belong to this table. |
| ConflictOption | Specifies which System.Data.ConflictOption is to be used by the DbDataTable. |
| Connection | Gets or sets the System.Data.IDbConnection used to connect to the data source. |
| Constraints | Gets the collection of constraints maintained by this table. |
| Container | Gets the container for the component. (Inherited from System.ComponentModel.MarshalByValueComponent) |
| DataSet | Gets the System.Data.DataSet to which this table belongs. (Inherited from System.Data.DataTable) |
| DefaultView | Gets a customized view of the table that may include a filtered view, or a cursor position. (Inherited from System.Data.DataTable) |
| DeleteCommand | Gets or sets a SQL statement to delete records from the data set. |
| DesignMode | Gets a value indicating whether the component is currently in design mode. (Inherited from System.ComponentModel.MarshalByValueComponent) |
 | DisableListChangedEvents | Disables some of the events, which occurs when DbDataTable content is changed. |
| DisplayExpression | Gets 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) |
| ExtendedProperties | Gets the collection of customized user information. (Inherited from System.Data.DataTable) |
| FetchAll | Determines whether data is requested from server entirely or partially. |
| HasErrors | Gets 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) |
| InsertCommand | Gets or sets a SQL statement to insert new records into the data source. |
| IsInitialized | Gets a value that indicates whether the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable) |
| Locale | Gets or sets the locale information used to compare strings within the table. (Inherited from System.Data.DataTable) |
| MaxRecords | Gets or sets max number of records to fetch starting from StartRecord. |
| MinimumCapacity | Gets or sets the initial starting size for this table. (Inherited from System.Data.DataTable) |
| MissingSchemaAction | Determines the action to take when existing DataSet schema does not match incoming data. |
| Name | Gets or sets name of the component. |
| Namespace | Gets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable) |
| NonBlocking | Gets or sets data request mode. |
| Owner | Gets or sets form that the component resides on. |
| ParentRelation | Gets or sets a ParentDataRelation object that is used for server side master-detail relation. |
| ParentRelations | Gets the collection of parent relations for this System.Data.DataTable. (Inherited from System.Data.DataTable) |
| Prefix | Gets or sets the namespace for the XML representation of the data stored in the System.Data.DataTable. (Inherited from System.Data.DataTable) |
| PrimaryKey | Gets or sets an array of columns that function as primary keys for the data table. |
| QueryRecordCount | Determines whether DbDataTable should perfrom additional request to determine quantity of records in the result set. |
| Quoted | Gets or sets whether the DbDataTable quotes all the names of data source objects. |
| RecordCount | Gets number of rows in the result set. |
| RefreshingFields | Gets or sets list of fields whose values should be retrieved after a DML statement execution. |
| RefreshMode | Gets or sets a value that indicates whether and how the DbDataTable should retrieve field values adjusted by server after an update. |
| RemotingFormat | Gets or sets a System.Data.SerializationFormat for the DbDataTable used during remoting. |
| ReturnProviderSpecificTypes | Determines whether to use provider-specific types whenever possible. |
| Rows | Gets the collection of rows that belong to this table. (Inherited from System.Data.DataTable) |
| SchemaTable | Gets the schema table corresponding to the SelectCommand query. |
| SelectCommand | Gets or sets a SQL statement used to select records in the data source. |
| Site | Gets or sets an System.ComponentModel.ISite for the System.Data.DataTable. (Inherited from System.Data.DataTable) |
| StartRecord | Gets or sets record number to start. |
| SyncRoot | Gets an object that can be used to synchronize access to the System.Data.DataTable.Rows collection. |
| TableMapping | Gets a System.Data.Common.DataTableMapping that provides the master mapping between a source table and a DbDataTable. |
| TableName | Gets or sets the name of the System.Data.DataTable. (Inherited from System.Data.DataTable) |
| UpdateBatchSize | 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. |
| UpdateCommand | Gets or sets a SQL statement used to update records in the data source. |
| UpdatingFields | Gets or sets string containing list of field names used to generate update commands. |
| UpdatingKeyFields | Gets or sets string containing list of key field names separated by semicolon. They are used to generate update commands. |
| UpdatingTable | Gets or sets table name to generate update statements for. |
DbDataTable Class Members
In This Topic
The following tables list the members exposed by DbDataTable.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | AcceptChanges | Commits all the changes made to this table since the last time System.Data.DataTable.AcceptChanges was called. (Inherited from System.Data.DataTable) |
| BeginFill | Starts an asynchronous invocation of the Fill() method. |
| BeginInit | Begins 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) |
| BeginLoadData | Turns off notifications, index maintenance, and constraints while loading data. (Inherited from System.Data.DataTable) |
| CancelFetch | Stops asynchronous fill operation. |
| Clear | Clears DbDataTable and stops Fill operation. |
| Clone | Overridden. Clones the structure of the DbDataTable, including all System.Data.DataTable schemes and constraints. |
| Close | Disconnects DbDataTable from the data source and frees server resources allocated for the query. |
| Compute | Computes the given expression on the current rows that pass the filter criteria. (Inherited from System.Data.DataTable) |
| Copy | Copies both the structure and data for this System.Data.DataTable. (Inherited from System.Data.DataTable) |
| CreateDataReader | Returns a System.Data.DataTableReader corresponding to the data within this System.Data.DataTable. (Inherited from System.Data.DataTable) |
| Dispose() | Releases all resources used by the System.ComponentModel.MarshalByValueComponent. (Inherited from System.ComponentModel.MarshalByValueComponent) |
| EndFill | Ends an asynchronous invocation of the Fill() method. |
| EndInit | Overridden. Ends the initialization of a DbDataTable that is used on a form or used by another component. The initialization occurs at run time. |
| EndLoadData | Turns on notifications, index maintenance, and constraints after loading data. (Inherited from System.Data.DataTable) |
| Fill | Overloaded. Fills the System.Data.DataTable.Rows collection of the DbDataTable with rows from the data source. |
| FillPage | Overloaded. 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. |
| FillSchema | Configures the schema to match that in the data source. |
| GetChanges | Overloaded. 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) |
| GetErrors | Gets an array of System.Data.DataRow objects that contain errors. (Inherited from System.Data.DataTable) |
| GetObjectData | Populates a serialization information object with the data needed to serialize the System.Data.DataTable. (Inherited from System.Data.DataTable) |
| GetService | Gets the implementer of the System.IServiceProvider. (Inherited from System.ComponentModel.MarshalByValueComponent) |
| ImportRow | Copies 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) |
| Load | Overloaded. 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) |
| LoadDataRow | Overloaded. 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) |
| Merge | Overloaded. Merge the specified System.Data.DataTable with the current System.Data.DataTable. (Inherited from System.Data.DataTable) |
| NewRow | Creates a new System.Data.DataRow with the same schema as the table. (Inherited from System.Data.DataTable) |
| Open | Fetches data and sets the Active property to true. |
| Read | Reads the next data row when DbDataTable operates in connected model. |
| ReadComplete | Fills a row with data not fetched in the initial fill operation. |
| ReadXml | Overloaded. Reads XML schema and data into the System.Data.DataTable using the specified System.IO.Stream. (Inherited from System.Data.DataTable) |
| ReadXmlSchema | Overloaded. Reads an XML schema into the System.Data.DataTable using the specified stream. (Inherited from System.Data.DataTable) |
| RefreshRow | Refreshes the specified row with values from server. |
| RejectChanges | Rolls 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) |
| Reset | Resets 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) |
| Select | Overloaded. Gets an array of DataRow objects. |
| SuspendFill | Overloaded. Suspends asynchronous fill operation. |
| ToString | Gets the System.Data.DataTable.TableName and System.Data.DataTable.DisplayExpression, if there is one as a concatenated string. (Inherited from System.Data.DataTable) |
| Update | Executes the appropriate commands to delete, insert, or update rows in the data source. |
| UpdateRows | Executes the appropriate commands to delete, insert, or update the specified rows in the data source. |
| WriteXml | Overloaded. Writes the current contents of the System.Data.DataTable as XML using the specified System.IO.Stream. (Inherited from System.Data.DataTable) |
| WriteXmlSchema | Overloaded. Writes the current data structure of the System.Data.DataTable as an XML schema to the specified stream. (Inherited from System.Data.DataTable) |
Public Events
| Name | Description | |
|---|---|---|
 | ColumnChanged | Occurs after a value has been changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable) |
| ColumnChanging | Occurs when a value is being changed for the specified System.Data.DataColumn in a System.Data.DataRow. (Inherited from System.Data.DataTable) |
| Disposed | Adds an event handler to listen to the Disposed event on the component. |
| FetchFinished | Occurs when a result set is completely fetched. |
| FillError | Occurs when an error is raised during a fill operation. |
| Initialized | Occurs after the System.Data.DataTable is initialized. (Inherited from System.Data.DataTable) |
| RowChanged | Occurs after a System.Data.DataRow has been changed successfully. (Inherited from System.Data.DataTable) |
| RowChanging | Occurs when a System.Data.DataRow is changing. (Inherited from System.Data.DataTable) |
| RowDeleted | Occurs after a row in the table has been deleted. (Inherited from System.Data.DataTable) |
| RowDeleting | Occurs before a row in the table is about to be deleted. (Inherited from System.Data.DataTable) |
| RowFetched | Occurs when another row is completely fetched. |
| TableCleared | Occurs after a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable) |
| TableClearing | Occurs when a System.Data.DataTable is cleared. (Inherited from System.Data.DataTable) |
| TableNewRow | Occurs when a new System.Data.DataRow is inserted. (Inherited from System.Data.DataTable) |
See Also