Create(TCustomClrDataSet)

Initializes a new instance of the TDbRecordset class.

Destroy

Represents the destructor of the TDbRecordset class.

ReadOnly

Specifies whether the dataset is read-only.

AbsolutePosition

Sets or returns a value that specifies the ordinal position of the current record in the Recordset object.

ActiveCommand

Returns the Command object associated with the Recordset.

ActiveConnection

Sets or returns a definition for a connection if the connection is closed, or the current Connection object if the connection is open.

ActiveDataAdapter

Returns the DataAdapter object associated with the Recordset.

ApplyDefaultSort

Gets or sets a value that indicates whether to use the default sort. The default sort is (ascending) by all primary keys as specified by PrimaryKey.

BOF

Returns true if the current record position is before the first record, otherwise false.

Bookmark

Sets or returns a bookmark. The bookmark saves the position of the current record.

CaseSensitive

Indicates whether string comparisons within the Recordset are case-sensitive.

Columns

Gets the collection of columns that belong to this Recordset.

DataRow

Gets the collection of rows that belong to this Recordset.

DataRowView

Represents a customized view of a DataRow.

DataSet

Provides direct access to the ADO.Net DataSet object.

DataSetRef

Represents property DataSetRef.

DataTable

Provides direct access to the ADO.Net DataTable object.

DataView

Provides direct access to the ADO.Net DataView object.

EnforceConstraints

Gets or sets a value indicating whether constraint rules are followed when attempting any update operation.

EOF

Returns true if the current record position is after the last record, otherwise false.

ExtendedProperties

Gets the collection of customized user information.

FetchingInProgress

Returns true if there are more data to be fetched from the database or when fetching of data from database is in progress.

FetchOptions

The set of options to control rows fetching.

Fields

Indicates the number of Field objects in the Recordset object.

Filter

Sets or returns a filter for the data in a Recordset object.

Index

Sets or returns the name of the current index for a Recordset object.

Locale

Gets or sets the locale information used to compare strings within the Recordset.

Namespace

Gets or sets the namespace for the XML representation of the data stored in the Recordset.

Prefix

Gets or sets the namespace for the XML representation of the data stored in the Recordset.

PrimaryKey

Gets or sets an array of columns that function as primary keys for the data table.

Reader

Returns the DataReader object associated with the Recordset.

RecordCount

Returns the number of records in a Recordset object.

RecordsAffected

Gets the number of rows changed, inserted, or deleted by execution of the Transact-SQL statement.

RemotingFormat

Gets or sets a SerializationFormat for the Recordset used during remoting.

RowError

Gets or sets the custom error description for a row in a recordset.

Rows

Gets the collection of rows that belong to this recordset.

Rowstate

Gets the current state of the row with regard to its relationship to the DataRowCollection in a recordset.

RowStateFilter

Gets or sets the row state filter used in a recordset.

RowVersion

Gets the current version description of the DataRow in a recordset.

SchemaTable

Returns a DataTable that describes the column metadata of the recordset.

Sort

Gets or sets the sort column or columns, and sort order for the recordset.

State

Returns a value that describes if the Recordset object is open, closed, connecting, executing or retrieving data.

TableIndex

Gets the index of the current table in the recordset.

UpdateOptions

The set of options to control updates posting.

UpdatesPending

Indicates whether the changes log is not empty.

AddNew

Creates a new record.

BeginInit

Starts the initialization of a recordset that is used on a form or used by another component. The initialization occurs at runtime.

Cancel

Cancels an execution.

CancelBatch

Cancels a batch update.

CancelUpdate

Cancels changes made to a record of a Recordset object.

Clone

Creates a duplicate of an existing Recordset.

Close

Closes a Recordset.

CloseReader

Closes the DataReader associated with the Recordset.

CompareBookmarks(Olevariant,Olevariant)

Compares two bookmarks.

Compute(WideString,WideString)

Computes the given expression on the current rows that pass the filter criteria.

CopyTo(_Array,Integer)

Copies items into an array.

CreateDataReader

Returns a DataTableReader corresponding to the data within this Recordset.

Delete

Deletes a record or a group of records.

DoAddRemoveColumnChangedEvent

Represents method DoAddRemoveColumnChangedEvent.

DoAddRemoveColumnChangingEvent

Represents method DoAddRemoveColumnChangingEvent.

DoAddRemoveEvents

Represents method DoAddRemoveEvents.

DoAddRemoveRowChangedEvent

Represents method DoAddRemoveRowChangedEvent.

DoAddRemoveRowChangingEvent

Represents method DoAddRemoveRowChangingEvent.

DoAddRowUpdatedEvent(TDbDataAdapter)

Represents method DoAddRowUpdatedEvent(TDbDataAdapter).

DoInternalCloseIfReaderIsClosed

Represents method DoInternalCloseIfReaderIsClosed.

DoOptionPropertyChanged(TObject,string)

Represents method DoOptionPropertyChanged(TObject,string).

DoRemoveRowUpdatedEvent(TDbDataAdapter)

Represents method DoRemoveRowUpdatedEvent(TDbDataAdapter).

DoUpdateData

Represents method DoUpdateData.

EndInit

Ends the initialization of a Recordset that is used on a form or used by another component. The initialization occurs at runtime.

Find(Olevariant)

Finds a row in the Recordset by the specified sort key value.

Find(_ObjectArray)

Finds a row in the Recordset by the specified sort key values.

FindRecord(WideString)

Checks if the record exists that match the filter criteria.

FindRows(Olevariant)

Returns an array of DataRowView objects whose columns match the specified sort key value.

FindRows(_ObjectArray)

Returns an array of DataRowView objects whose columns match the specified sort key value.

GetAbsolutePosition

Represents method GetAbsolutePosition.

GetActiveCommand

Represents method GetActiveCommand.

GetActiveConnection

Represents method GetActiveConnection.

GetActiveDataAdapter

Represents method GetActiveDataAdapter.

GetApplyDefaultSort

Represents method GetApplyDefaultSort.

GetBOF

Represents method GetBOF.

GetBookmark

Represents method GetBookmark.

GetCaseSensitive

Represents method GetCaseSensitive.

GetChanges

Gets a copy of the DataTable that contains all changes made to it since it was loaded or AcceptChanges was last called.

GetChanges(TDataRowState_Set)

Gets a copy of the DataTable containing all changes made to it since it was last loaded, or since AcceptChanges was called, filtered by DataRowState.

GetColumns

Represents method GetColumns.

GetDataRow

Represents method GetDataRow.

GetDataRowView

Represents method GetDataRowView.

GetDataSet

Represents method GetDataSet.

GetDataTable

Represents method GetDataTable.

GetDataView

Represents method GetDataView.

GetEnforceConstraints

Represents method GetEnforceConstraints.

GetEOF

Represents method GetEOF.

GetErrors

Represents method GetErrors.

GetExtendedProperties

Represents method GetExtendedProperties.

GetFetchingInProgress

Represents method GetFetchingInProgress.

GetFields

Represents method GetFields.

GetFilter

Represents method GetFilter.

GetIndex

Represents method GetIndex.

GetInternalRecordCount

Represents method GetInternalRecordCount.

GetLocale

Represents method GetLocale.

GetNamespace

Represents method GetNamespace.

GetPrefix

Represents method GetPrefix.

GetPrimaryKey

Represents method GetPrimaryKey.

GetReadOnly

Represents method GetReadOnly.

GetRecordCountAsInt32

Represents method GetRecordCountAsInt32.

GetRecordsAffected

Represents method GetRecordsAffected.

GetRemotingFormat

Represents method GetRemotingFormat.

GetRowError

Represents method GetRowError.

GetRows

Represents method GetRows.

GetRowstate

Represents method GetRowstate.

GetRowStateFilter

Represents method GetRowStateFilter.

GetRowVersion

Represents method GetRowVersion.

GetSort

Represents method GetSort.

GetState

Represents method GetState.

GetTableIndex

Represents method GetTableIndex.

GetUpdatesPending

Represents method GetUpdatesPending.

GetXml

Returns the XML representation of the data stored in the Recordset.

GetXmlSchema

Returns the XML Schema for the XML representation of the data stored in the Recordset.

Get_RecordCount

Represents method Get_RecordCount.

Get_SchemaTable

Represents method Get_SchemaTable.

HasChanges

Gets a value indicating whether the Recordset has changes, including new, deleted, or modified rows.

HasChanges(TDataRowState_Set)

Gets a value indicating whether the Recordset has changes, including new, deleted, or modified rows, filtered by DataRowState.

ImportRow(_DataRow)

Copies a DataRow into a Recordset, preserving any property settings, as well as original and current values.

InitializeDataSet

Represents method InitializeDataSet.

IsNull(Integer)

Gets a value that indicates whether the column at the specified index contains a null value.

IsNull(WideString)

Gets a value that indicates whether the named column contains a null value.

Load(_IDataReader)

Fills a Recordset with values from a data source using the supplied IDataReader. If the Recordset already contains rows, the incoming data from the data source is merged with the existing rows.

Load(_IDataReader,TLoadOption)

Fills a Recordset with values from a data source using the supplied IDataReader. If the DataTable already contains rows, the incoming data from the data source is merged with the existing rows according to the value of the loadOption parameter.

LoadAll(Boolean)

Fetch all data from the database.

LoadDataRow(_ObjectArray,Boolean)

Finds and updates a specific row. If no matching row is found, a new row is created using the given values.

LoadDataRow(_ObjectArray,TLoadOption)

Finds and updates a specific row. If no matching row is found, a new row is created using the given values.

Merge(_DataTable)

Merge the specified DataTable with the Recordset.

Merge(_DataTable,Boolean)

Merge the specified DataTable with the Recordset, indicating whether to preserve changes in the Recordset.

Merge(_DataTable,Boolean,TMissingSchemaAction)

Merge the specified DataTable with the Recordset, indicating whether to preserve changes and how to handle missing schema in the Recordset.

Move(Integer)

Moves the record pointer in a Recordset object.

MoveFirst

Moves the record pointer to the first record

MoveLast

Moves the record pointer to the last record.

MoveNext

Moves the record pointer to the next record.

MovePrevious

Moves the record pointer to the previous record.

NextRecordset

Clears the current Recordset object and returns the next Recordset object by looping through a series of commands.

Open

Opens a database element that gives you access to records in a table, the results of a query.

ReadXml(WideString)

Represents method ReadXml(WideString).

ReadXmlSchema(WideString)

Represents method ReadXmlSchema(WideString).

Refresh

Represents method Refresh.

RefreshDataSet

Represents method RefreshDataSet.

Requery

Updates the data in a Recordset by re-executing the query that made the original Recordset.

RevertRecord

Represents method RevertRecord.

Seek(_ObjectArray)

Searches the index of a Recordset to find a record that matches the specified values.

Select

Gets an array of all DataRow objects.

Select(WideString)

Gets an array of all DataRow objects that match the filter criteria.

Select(WideString,WideString)

Gets an array of all DataRow objects that match the filter criteria, in the specified sort order.

Select(WideString,WideString,TDataViewRowState_Set)

Gets an array of all DataRow objects that match the filter in the order of the sort that match the specified state.

SetAbsolutePosition(Integer)

Represents method SetAbsolutePosition(Integer).

SetActiveCommand(TDbCommand)

Represents method SetActiveCommand(TDbCommand).

SetActiveConnection(TDbConnection)

Represents method SetActiveConnection(TDbConnection).

SetAdded

Changes the Rowstate of a recordset DataRow to added.

SetApplyDefaultSort(Boolean)

Represents method SetApplyDefaultSort(Boolean).

SetBookmark(Olevariant)

Represents method SetBookmark(Olevariant).

SetCaseSensitive(Boolean)

Represents method SetCaseSensitive(Boolean).

SetDataSet(_DataSet)

Sets a new DataSet in the Recordset.

SetDataTable(_DataTable)

Sets a new DataTable in the Recordset.

SetDataView(_DataView)

Represents method SetDataView(_DataView).

SetEnforceConstraints(Boolean)

Represents method SetEnforceConstraints(Boolean).

SetFilter(WideString)

Represents method SetFilter(WideString).

SetFilterGroup(TDataViewRowState_Set)

Sets the row state filter used in the RecordSet.

SetIndex(WideString)

Represents method SetIndex(WideString).

SetLocale(_CultureInfo)

Represents method SetLocale(_CultureInfo).

SetModified

Changes the Rowstate of a recordset DataRow to Modified.

SetNamespace(WideString)

Represents method SetNamespace(WideString).

SetPrefix(WideString)

Represents method SetPrefix(WideString).

SetPrimaryKey(_DataColumnArray)

Represents method SetPrimaryKey(_DataColumnArray).

SetReadonly

Allows to control the recordset read-write or read-only mode.

SetRemotingFormat(TSerializationFormat)

Represents method SetRemotingFormat(TSerializationFormat).

SetRowStateFilter(TDataViewRowState_Set)

Represents method SetRowStateFilter(TDataViewRowState_Set).

SetSort(WideString)

Represents method SetSort(WideString).

Set_DataSet(_DataSet)

Represents method Set_DataSet(_DataSet).

Set_DataTable(_DataTable)

Represents method Set_DataTable(_DataTable).

Set_ReadOnly(Boolean)

Represents method Set_ReadOnly(Boolean).

Truncate

Closes the reader associated with the Recordset.

Update(Boolean)

Saves all changes made to a single record  in a Recordset object.

UpdateBatch

Saves all changes in a Recordset to the database. Used when working in batch update mode.

WriteXml(WideString)

Writes the current contents of the Recordset as XML using the specified file.

WriteXml(WideString,Boolean)

Writes the current contents of the Recordset as XML using the specified file. To save the data for the table and all its descendants, set the writeHierarchy parameter to true.

WriteXml(WideString,TXmlWriteMode)

Writes the current data, and optionally the schema, for the Recordset using the specified file and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema.

WriteXml(WideString,TXmlWriteMode,Boolean)

Writes the current data, and optionally the schema, for the Recordset using the specified file and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema. To save the data for the table and all its descendants, set the writeHierarchy parameter to true.

WriteXmlSchema(WideString)

Writes the current data structure of the Recordset as an XML schema to the specified file.

WriteXmlSchema(WideString,Boolean)

Writes the current data structure of the Recordset as an XML schema to the specified file. To save the schema for the table and all its descendants, set the writeHierarchy parameter to true.

OnColumnChanged

Occurs after a value has been changed for the specified DataColumn in a DataRow.

OnColumnChanging

Occurs when a value is being changed for the specified DataColumn in a DataRow.

OnFetchComplete

Occurs after records have been retrieved into the recordset.

OnFetchProgress

Occurs periodically during an asynchronous data retrieval operation.

OnRowChanged

Occurs after a DataRow has been changed successfully.

OnRowChanging

Occurs when a DataRow is changing.

OnUpdateError

Occurs if an exception is generated when updates are applied to a database.

OnUpdateRecord

Occurs when record update is applying to a database.