Create(TComponent)

Initializes a new instance of the TSqlClientCommand class. (Overrides CNClrLib.ADONet.Client.TDbCommand.Create(TComponent).)

Destroy

Represents the destructor of the TSqlClientCommand class. (Overrides CNClrLib.ADONet.Client.TDbCommand.Destroy.)

CommandIntf

Provides direct access to ADO.Net SqlCommand object

CommandText

Specifies command to execute.

CommandTextAlias

Represents property CommandTextAlias. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

CommandTimeout

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

CommandType

Specifies the type of command to execute.

ComponentRef

Represents property ComponentRef. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Connection

Gets or sets the SqlClientConnection used by this instance of the SqlClientCommand.

NativeCommandText

Represents property NativeCommandText. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

NotificationAutoEnlist

Gets or sets a value indicating whether the application should automatically receive query notifications from a common SqlDependency object.

NotificationIntf

Gets or sets a value that specifies the SqlNotificationRequest object bound to this command.

OnCancel

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

OnCommandTextChange

The event fires after CommandText is changed.

OnExecute

The event fires after the SqlClientCommand is executed.

OnPrepare

The event fires after the SqlClientCommand is prepared.

ParamCheck

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

Parameters

Contains the parameters for an SqlClientCommand object's SQL statement.

Prepared

Specifies whether the SqlClientCommand is prepared before execution.

TransactionIntf

Provides direct access to the ADO.Net SqlTransaction object.

UpdatedRowSource

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

UpdateRowSource

Represents property UpdateRowSource. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ApplyParamValues(Variant[],TFieldType[])

Represents method ApplyParamValues(Variant[],TFieldType[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Assign(TPersistent)

Represents method Assign(TPersistent). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

AssignCommandText(TStrings,Boolean)

Represents method AssignCommandText(TStrings,Boolean). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Cancel

Represents method Cancel. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

CheckCommandText

Represents method CheckCommandText. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

CheckConnectionActive

Represents method CheckConnectionActive. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

CheckConnectionInactive

Represents method CheckConnectionInactive. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Clone

Makes one SqlClientCommand component a copy of another.

CommandTextChanged(TObject)

Represents method CommandTextChanged(TObject). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ComponentLoading

Represents method ComponentLoading. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ConnectionStateChange(TObject,Boolean)

Represents method ConnectionStateChange(TObject,Boolean). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

CreateParameters(TDbCommand)

Represents method CreateParameters(TDbCommand). (Overrides CNClrLib.ADONet.Client.TDbCommand.CreateParameters(TDbCommand).)

CreateSqlParameters(TSqlClientCommand)

Represents method CreateSqlParameters(TSqlClientCommand).

DoCancelCommand

Represents method DoCancelCommand. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoExecuteNonQuery

Represents method DoExecuteNonQuery. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoExecuteQuery

Represents method DoExecuteQuery. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoExecuteReader

Overloaded. Represents method DoExecuteReader. (Overrides CNClrLib.ADONet.Client.TDbCommand.DoExecuteReader.)

DoExecuteReader(TCommandBehavior_Set)

Overloaded. Represents method DoExecuteReader(TCommandBehavior_Set). (Overrides CNClrLib.ADONet.Client.TDbCommand.DoExecuteReader(TCommandBehavior_Set).)

DoExecuteScalar

Represents method DoExecuteScalar. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoExecuteXmlReader

Represents method DoExecuteXmlReader.

DoGetCloneCommand

Represents method DoGetCloneCommand. (Overrides CNClrLib.ADONet.Client.TDbCommand.DoGetCloneCommand.)

DoGetCloneSqlCommand

Represents method DoGetCloneSqlCommand.

DoGetDbCommand

Represents method DoGetDbCommand. (Overrides CNClrLib.ADONet.Client.TDbCommand.DoGetDbCommand.)

DoInitializeCommand

Represents method DoInitializeCommand. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoOnCancel

Represents method DoOnCancel. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoOnCommandTextChanged

Represents method DoOnCommandTextChanged. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoOnExecute

Represents method DoOnExecute. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoOnPrepare

Represents method DoOnPrepare. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoOpenConnection

Represents method DoOpenConnection. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoPrepare

Represents method DoPrepare. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

DoSqlExecuteReader

Overloaded. Represents method DoSqlExecuteReader.

DoSqlExecuteReader(TCommandBehavior_Set)

Overloaded. Represents method DoSqlExecuteReader(TCommandBehavior_Set).

Execute

Overloaded. Represents method Execute. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Execute(Variant[])

Overloaded. Represents method Execute(Variant[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Execute(Variant[],TFieldType[])

Overloaded. Represents method Execute(Variant[],TFieldType[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteNonQuery

Overloaded. Represents method ExecuteNonQuery. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteNonQuery(Variant[])

Overloaded. Represents method ExecuteNonQuery(Variant[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteNonQuery(Variant[],TFieldType[])

Overloaded. Represents method ExecuteNonQuery(Variant[],TFieldType[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteReader

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

ExecuteReader(TCommandBehavior_Set)

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

ExecuteReader(Variant[])

Overloaded. Represents method ExecuteReader(Variant[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteReader(Variant[],TFieldType[])

Overloaded. Represents method ExecuteReader(Variant[],TFieldType[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteScalar

Overloaded. Represents method ExecuteScalar. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteScalar(Variant[])

Overloaded. Represents method ExecuteScalar(Variant[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteScalar(Variant[],TFieldType[])

Overloaded. Represents method ExecuteScalar(Variant[],TFieldType[]). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ExecuteXmlReader

Sends the CommandText to the Connection and builds an XmlReader object.

FindParam(string)

Finds the parameter in Parameters property by a given name.

GetDbParameters

Represents method GetDbParameters. (Overrides CNClrLib.ADONet.Client.TDbCommand.GetDbParameters.)

GetNativeCommandText

Represents method GetNativeCommandText. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

GetParameterClass

Represents method GetParameterClass. (Overrides CNClrLib.ADONet.Client.TDbCommand.GetParameterClass.)

GetParameterCollectionClass

Represents method GetParameterCollectionClass. (Overrides CNClrLib.ADONet.Client.TDbCommand.GetParameterCollectionClass.)

GetSqlConnection

Represents method GetSqlConnection.

GetTransactionIntf

Represents method GetTransactionIntf. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Initialize(Boolean)

Represents method Initialize(Boolean). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

Loaded

Represents method Loaded. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ParamByName(string)

Returns parameter by its name.

Prepare

Represents method Prepare. (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

ResetCommandTimeout

Resets the CommandTimeout property to the default value.

SetConnection(TDbConnection)

Overloaded. Represents method SetConnection(TDbConnection). (Overrides CNClrLib.ADONet.Client.TDbCommand.SetConnection(TDbConnection).)

SetConnectionFlag(Integer,Boolean)

Represents method SetConnectionFlag(Integer,Boolean). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

SetDbParameters(TDbParameters)

Represents method SetDbParameters(TDbParameters). (Overrides CNClrLib.ADONet.Client.TDbCommand.SetDbParameters(TDbParameters).)

SetSqlConnection(TSqlClientConnection)

Represents method SetSqlConnection(TSqlClientConnection).

SetTransactionIntf(_DbTransaction)

Represents method SetTransactionIntf(_DbTransaction). (Inherited from CNClrLib.ADONet.Client.TDbCommand.)

OnStatementCompleted

Occurs when the execution of a Transact-SQL statement completes.