Create(TComponent)

Initializes a new instance of the TDbCommand class.

Destroy

Represents the destructor of the TDbCommand class.

CommandIntf

Provides direct access to the ADO.Net DbCommand object.

CommandText

Specifies command to execute.

CommandTextAlias

Represents property CommandTextAlias.

CommandTimeout

Specifies the amount of time to attempt execution of the command.

CommandType

Specifies the type of command to execute.

ComponentRef

Represents property ComponentRef.

Connection

Specifies ADO.Net connection component to use.

NativeCommandText

Represents property NativeCommandText.

OnCancel

The event fires after the execution of the command is cancelled.

OnCommandTextChange

The event fires after CommandText is changed.

OnExecute

The event fires after the command is executed.

OnPrepare

The event fires after the command is prepared.

ParamCheck

Specifies whether the parameter list for an ADO.Net command component is regenerated if the SQL changes at runtime.

Parameters

Contains the parameters for an ADO.Net command object's SQL statement.

Prepared

Specifies whether the command is prepared before execution.

TransactionIntf

Provides direct access to the ADO.Net DbTransaction object.

UpdatedRowSource

Gets or sets how command results are applied to the DataRow when used by the Update method of a DbDataAdapter.

UpdateRowSource

Represents property UpdateRowSource.

ApplyParamValues(Variant[],TFieldType[])

Represents method ApplyParamValues(Variant[],TFieldType[]).

Assign(TPersistent)

Makes one ADO.Net command component a duplicate of another.

AssignCommandText(TStrings,Boolean)

Represents method AssignCommandText(TStrings,Boolean).

Cancel

Attempts to cancels the execution of the Command.

CheckCommandText

Check to see if the command SQL is not empty.

CheckConnectionActive

Check to see if the command connection is active.

CheckConnectionInactive

Check to see if the command connection is not active.

Clone

Makes one ADO.Net command component a copy of another.

CommandTextChanged(TObject)

Represents method CommandTextChanged(TObject).

ComponentLoading

Represents method ComponentLoading.

ConnectionStateChange(TObject,Boolean)

Represents method ConnectionStateChange(TObject,Boolean).

CreateParameters(TDbCommand)

Represents method CreateParameters(TDbCommand).

DoCancelCommand

Represents method DoCancelCommand.

DoExecuteNonQuery

Represents method DoExecuteNonQuery.

DoExecuteQuery

Represents method DoExecuteQuery.

DoExecuteReader

Overloaded. Represents method DoExecuteReader.

DoExecuteReader(TCommandBehavior_Set)

Overloaded. Represents method DoExecuteReader(TCommandBehavior_Set).

DoExecuteScalar

Represents method DoExecuteScalar.

DoGetCloneCommand

Represents method DoGetCloneCommand.

DoGetDbCommand

Represents method DoGetDbCommand.

DoInitializeCommand

Represents method DoInitializeCommand.

DoOnCancel

Represents method DoOnCancel.

DoOnCommandTextChanged

Represents method DoOnCommandTextChanged.

DoOnExecute

Represents method DoOnExecute.

DoOnPrepare

Represents method DoOnPrepare.

DoOpenConnection

Represents method DoOpenConnection.

DoPrepare

Represents method DoPrepare.

Execute

Executes the query and returns ADO.Net DataTable.

Execute(Variant[])

Executes the query by specifying an array of the parameter values and returns ADO.Net DataTable.

Execute(Variant[],TFieldType[])

Executes the query by specifying an array of the parameter values and data types and returns ADO.Net DataTable.

ExecuteNonQuery

Executes a SQL statement against a connection object.

ExecuteNonQuery(Variant[])

Executes a SQL statement against a connection object by specifying an array of the parameter values.

ExecuteNonQuery(Variant[],TFieldType[])

Executes a SQL statement against a connection object by specifying an array of the parameter values and data types.

ExecuteReader

Executes the CommandText against the Connection component, and returns an DbDataReader.

ExecuteReader(TCommandBehavior_Set)

Executes the CommandText against the Connection, and returns an DbDataReader using one of the CommandBehavior values.

ExecuteReader(Variant[])

Executes the CommandText against the Connection, and returns an DbDataReader using an array of the parameter values.

ExecuteReader(Variant[],TFieldType[])

Executes the CommandText against the Connection, and returns an DbDataReader using an array of the parameter values and data types.

ExecuteScalar

Executes the query and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored.

ExecuteScalar(Variant[])

Executes the query by specifying an array of the parameter values and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored.

ExecuteScalar(Variant[],TFieldType[])

Executes the query by specifying an array of the parameter values and data types and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored.

FindParam(string)

Finds the parameter in Params property by a given name.

GetDbParameters

Represents method GetDbParameters.

GetNativeCommandText

Represents method GetNativeCommandText.

GetParameterClass

Represents method GetParameterClass.

GetParameterCollectionClass

Represents method GetParameterCollectionClass.

GetTransactionIntf

Represents method GetTransactionIntf.

Initialize(Boolean)

Represents method Initialize(Boolean).

Loaded

Represents method Loaded.

ParamByName(string)

Returns parameter by its name.

Prepare

Prepares SQL command for execution.

SetConnection(TDbConnection)

Represents method SetConnection(TDbConnection).

SetConnectionFlag(Integer,Boolean)

Represents method SetConnectionFlag(Integer,Boolean).

SetDbParameters(TDbParameters)

Represents method SetDbParameters(TDbParameters).

SetTransactionIntf(_DbTransaction)

Represents method SetTransactionIntf(_DbTransaction).