GetCommandText Method

Gets the SQL command text template or stored procedure name for a SQL statement based on it's sequence number.

Syntax

Visual Basic

'Declaration
 
Public Function GetCommandText( _
   ByVal commandSequenceNumber As Integer _
) As String

C#

public string GetCommandText( 
   int commandSequenceNumber
)

Parameters

commandSequenceNumber

The sequence number of the currently executing SQL command within the overall scope of the present operation being performed.

Return Value

Either the name of a stored procedure (if stored procedures are supported), or the templatized SQL command text for use in a dynamic SQL statement.

Remarks

The caller of GetCommandText must perform any replacements of placeholders in the templatized text based on the binding members defined in a ScheduleDataBinding instance. Implementors of custom data providers can usually use BindStatement for this purpose.

Stored procedure names allow for no data binding replacements, please see the documentation for instructions on modifying and recompiling stored procedures to match your data model's naming conventions.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2