dotConnect for MongoDB Documentation
Devart.Common Namespace / DbDataTable Class
Fields Properties Methods Events


On this page
    DbDataTable Class Members
    On this page

    The following tables list the members exposed by DbDataTable.

    Protected Fields
     NameDescription
    Protected FieldcommandBuilder  
    Protected Internal Fieldconnection  
    Protected FieldcurrenSelectCommand  
    Protected FielddataAdapter  
    Protected Internal FielddataTable  
    Protected FielddetailSelectCommand  
    Protected Internal FielddisableEvents  
    Protected Internal FielddisableUpdateEvents  
    Protected Internal FieldfInitInProgress (Inherited from System.Data.DataTable)
    Protected FieldhasComplexFields  
    Protected FieldindexOfColumnOnlyOriginalValue  
    Protected FieldpropertyDescriptorsCache  
    Protected Fieldreader  
    Protected FieldreaderMappings  
    Protected FieldreturnProviderSpecificTypesInternal  
    Protected FieldschemaTable  
    Protected Internal FieldstoreEvents  
    Top
    Public Properties
     NameDescription
    Public PropertyActiveGets or sets whether a DbDataTable is filled with data from a data source.  
    Public PropertyCachedUpdatesEnables or disables cached updates mode.  
    Public PropertyCancelEditRowIfUpdateFailed  
    Public PropertyCaseSensitive (Inherited from System.Data.DataTable)
    Public PropertyChildRelations (Inherited from System.Data.DataTable)
    Public PropertyColumnsGets the collection of columns that belong to this table.  
    Public PropertyConflictOptionSpecifies which System.Data.ConflictOption is to be used by the DbDataTable.  
    Public PropertyConnectionGets or sets the System.Data.IDbConnection used to connect to the data source.  
    Public PropertyConstraintsGets the collection of constraints maintained by this table.  
    Public PropertyContainer (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public PropertyContinueUpdateOnError  
    Public PropertyDataSet (Inherited from System.Data.DataTable)
    Public PropertyDefaultView (Inherited from System.Data.DataTable)
    Public PropertyDeleteCommandGets or sets a SQL statement to delete records from the data set.  
    Public PropertyDesignMode (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public Propertystatic (Shared in Visual Basic)DisableListChangedEventsDisables some of the events, which occurs when DbDataTable content is changed.  
    Public PropertyDisplayExpression (Inherited from System.Data.DataTable)
    Public PropertyExtendedProperties (Inherited from System.Data.DataTable)
    Public PropertyFetchAllDetermines whether data is requested from server entirely or partially.  
    Public PropertyHasErrors (Inherited from System.Data.DataTable)
    Public PropertyInsertCommandGets or sets a SQL statement to insert new records into the data source.  
    Public PropertyIsInitialized (Inherited from System.Data.DataTable)
    Public PropertyLocale (Inherited from System.Data.DataTable)
    Public PropertyMaxRecordsGets or sets max number of records to fetch starting from StartRecord.  
    Public PropertyMinimumCapacity (Inherited from System.Data.DataTable)
    Public PropertyMissingSchemaActionDetermines the action to take when existing DataSet schema does not match incoming data.  
    Public PropertyNameGets or sets name of the component.  
    Public PropertyNamespace (Inherited from System.Data.DataTable)
    Public PropertyNonBlockingGets or sets data request mode.  
    Public PropertyOwnerGets or sets form that the component resides on.  
    Public PropertyParentRelationGets or sets a ParentDataRelation object that is used for server side master-detail relation.  
    Public PropertyParentRelations (Inherited from System.Data.DataTable)
    Public PropertyPrefix (Inherited from System.Data.DataTable)
    Public PropertyPrimaryKeyGets or sets an array of columns that function as primary keys for the data table.  
    Public PropertyQueryRecordCountDetermines whether DbDataTable should perfrom additional request to determine quantity of records in the result set.  
    Public PropertyQuotedGets or sets whether the DbDataTable quotes all the names of data source objects.  
    Public PropertyRecordCountGets number of rows in the result set.  
    Public PropertyRefreshingFieldsGets or sets list of fields whose values should be retrieved after a DML statement execution.  
    Public PropertyRefreshModeGets or sets a value that indicates whether and how the DbDataTable should retrieve field values adjusted by server after an update.  
    Public PropertyRemotingFormatGets or sets a System.Data.SerializationFormat for the DbDataTable used during remoting.  
    Public PropertyReturnProviderSpecificTypesDetermines whether to use provider-specific types whenever possible.  
    Public PropertyRows (Inherited from System.Data.DataTable)
    Public PropertySchemaTableGets the schema table corresponding to the SelectCommand query.  
    Public PropertySelectCommandGets or sets a SQL statement used to select records in the data source.  
    Public PropertySite (Inherited from System.Data.DataTable)
    Public PropertyStartRecordGets or sets record number to start.  
    Public PropertySyncRootGets an object that can be used to synchronize access to the System.Data.DataTable.Rows collection.  
    Public PropertyTableMappingGets a System.Data.Common.DataTableMapping that provides the master mapping between a source table and a DbDataTable.  
    Public PropertyTableName (Inherited from System.Data.DataTable)
    Public PropertyUpdateBatchSizeGets 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 PropertyUpdateCommandGets or sets a SQL statement used to update records in the data source.  
    Public PropertyUpdatingFieldsGets or sets string containing list of field names used to generate update commands.  
    Public PropertyUpdatingKeyFieldsGets or sets string containing list of key field names separated by semicolon. They are used to generate update commands.  
    Public PropertyUpdatingTableGets or sets table name to generate update statements for.  
    Top
    Protected Properties
     NameDescription
    Protected Internal PropertyCommandBuilderInternal  
    Protected Internal PropertyDataAdapterInternal  
    Protected PropertyEvents  
    Protected PropertyExecuteCommBehavior  
    Protected Internal PropertyReloading  
    Protected PropertyUserDefinedColumns  
    Top
    Public Methods
     NameDescription
    Public MethodAcceptChanges (Inherited from System.Data.DataTable)
    Public MethodBeginFillStarts an asynchronous invocation of the Fill() method.  
    Public MethodBeginInit (Inherited from System.Data.DataTable)
    Public MethodBeginLoadData (Inherited from System.Data.DataTable)
    Public MethodCancelFetchStops asynchronous fill operation.  
    Public MethodClearClears DbDataTable and stops Fill operation.  
    Public MethodCloneOverridden. Clones the structure of the DbDataTable, including all System.Data.DataTable schemes and constraints.  
    Public MethodCloseDisconnects DbDataTable from the data source and frees server resources allocated for the query.  
    Public MethodCompute (Inherited from System.Data.DataTable)
    Public MethodCopy (Inherited from System.Data.DataTable)
    Public MethodCreateDataReader (Inherited from System.Data.DataTable)
    Public MethodDisposeOverloaded. Overridden.   
    Public MethodEndFillEnds an asynchronous invocation of the Fill() method.  
    Public MethodEndInitOverridden. Ends the initialization of a DbDataTable that is used on a form or used by another component. The initialization occurs at run time.  
    Public MethodEndLoadData (Inherited from System.Data.DataTable)
    Public MethodFillOverloaded. Fills the System.Data.DataTable.Rows collection of the DbDataTable with rows from the data source.  
    Public MethodFillPageOverloaded. 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 MethodFillSchemaConfigures the schema to match that in the data source.  
    Public MethodGetChangesOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodGetErrors (Inherited from System.Data.DataTable)
    Public MethodGetObjectData (Inherited from System.Data.DataTable)
    Public MethodGetService (Inherited from System.ComponentModel.MarshalByValueComponent)
    Public MethodImportRow (Inherited from System.Data.DataTable)
    Public MethodLoadOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodLoadDataRowOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodMergeOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodNewRow (Inherited from System.Data.DataTable)
    Public MethodOpenOverloaded. Fetches data and sets the Active property to true.  
    Public MethodReadReads the next data row when DbDataTable operates in connected model.  
    Public MethodReadCompleteFills a row with data not fetched in the initial fill operation.  
    Public MethodReadXmlOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodReadXmlSchemaOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodRefreshRowRefreshes the specified row with values from server.  
    Public MethodRejectChanges (Inherited from System.Data.DataTable)
    Public MethodReset (Inherited from System.Data.DataTable)
    Public MethodSelectOverloaded. Gets an array of DataRow objects.  
    Public MethodSuspendFillOverloaded. Suspends asynchronous fill operation.  
    Public MethodToString (Inherited from System.Data.DataTable)
    Public MethodUpdateExecutes the appropriate commands to delete, insert, or update rows in the data source.  
    Public MethodUpdateRowsExecutes the appropriate commands to delete, insert, or update the specified rows in the data source.  
    Public MethodWriteXmlOverloaded.  (Inherited from System.Data.DataTable)
    Public MethodWriteXmlSchemaOverloaded.  (Inherited from System.Data.DataTable)
    Top
    Protected Methods
     NameDescription
    Protected MethodAddPropertyDescriptor  
    Protected MethodAddWhere  
    Protected MethodAfterUpdatingRow  
    Protected MethodBeforeUpdatingRow  
    Protected MethodCacheGetSchemaTable  
    Protected MethodCheckColumnsCreated  
    Protected MethodCheckDataAdapterCreated  
    Protected MethodCheckReaderMappings  
    Protected MethodCheckSelectCommand  
    Protected MethodClearSchemaTableCache  
    Protected MethodCloneCommand  
    Protected MethodCloneValue  
    Protected MethodCloseReader  
    Protected MethodColumnAdded  
    Protected MethodCreateColumns  
    Protected MethodCreateColumnsInternal  
    Protected MethodCreateDataAdapter  
    Protected MethodCreateInstance (Inherited from System.Data.DataTable)
    Protected MethodDecrementAutoIncrementCurrent  
    Protected MethodExecuteCommand  
    Protected MethodFetchCompleted  
    Protected MethodFetchToPosition  
    Protected MethodFinalize (Inherited from System.ComponentModel.MarshalByValueComponent)
    Protected MethodGetColumnNameFromMapping  
    Protected MethodGetConnection  
    Protected MethodGetDataRow  
    Protected MethodGetField  
    Protected Methodstatic (Shared in Visual Basic)GetIndexedFieldNames  
    Protected MethodGetParameterName  
    Protected MethodGetParameterPlaceholder  
    Protected MethodGetProperties  
    Protected MethodGetPropertyType  
    Protected MethodGetPropertyValue  
    Protected MethodGetRecordCount  
    Protected MethodGetRowType (Inherited from System.Data.DataTable)
    Protected MethodGetSchema (Inherited from System.Data.DataTable)
    Protected MethodGetSchemaTable  
    Protected MethodGetViewValue  
    Protected MethodInitNewRow  
    Protected Methodstatic (Shared in Visual Basic)IsCatchableExceptionType  
    Protected MethodMakeModifiedObjectTree  
    Protected MethodNeedCloneColumnValue  
    Protected Internal MethodNewRowArray (Inherited from System.Data.DataTable)
    Protected MethodNewRowFromBuilder (Inherited from System.Data.DataTable)
    Protected Internal MethodOnColumnChanged (Inherited from System.Data.DataTable)
    Protected Internal MethodOnColumnChanging (Inherited from System.Data.DataTable)
    Protected MethodOnPropertyChanging (Inherited from System.Data.DataTable)
    Protected MethodOnRemoveColumn (Inherited from System.Data.DataTable)
    Protected MethodOnRowChangedOverridden.   
    Protected MethodOnRowChangingOverridden.   
    Protected MethodOnRowDeletedOverridden.   
    Protected MethodOnRowDeletingOverridden.   
    Protected MethodOnTableCleared (Inherited from System.Data.DataTable)
    Protected MethodOnTableClearingOverridden.   
    Protected MethodOnTableNewRowOverridden.   
    Protected MethodOpenInternal  
    Protected MethodPrepare  
    Protected MethodRaiseFillError  
    Protected MethodReadXmlSerializable (Inherited from System.Data.DataTable)
    Protected MethodSetOwner  
    Protected MethodSetOwnerReal  
    Protected MethodSetPrimaryKey  
    Top
    Public Events
     NameDescription
    Public EventColumnChanged (Inherited from System.Data.DataTable)
    Public EventColumnChanging (Inherited from System.Data.DataTable)
    Public EventDisposedAdds an event handler to listen to the Disposed event on the component.  
    Public EventFetchFinishedOccurs when a result set is completely fetched.  
    Public EventFillErrorOccurs when an error is raised during a fill operation.  
    Public EventInitialized (Inherited from System.Data.DataTable)
    Public EventRowChanged (Inherited from System.Data.DataTable)
    Public EventRowChanging (Inherited from System.Data.DataTable)
    Public EventRowDeleted (Inherited from System.Data.DataTable)
    Public EventRowDeleting (Inherited from System.Data.DataTable)
    Public EventRowFetchedOccurs when another row is completely fetched.  
    Public EventTableCleared (Inherited from System.Data.DataTable)
    Public EventTableClearing (Inherited from System.Data.DataTable)
    Public EventTableNewRow (Inherited from System.Data.DataTable)
    Top
    See Also

    Reference

    DbDataTable Class
    Devart.Common Namespace

     

     

    © 2026 Devart. All Rights Reserved.

    Send Feedback