Prepares a SQL command to be executed. This should not normally be called outside of this class but is public in case the same statement needs to be executed over and over with different bind variables.

Namespace:  Asi.iBO
Assembly:  Asi.iBO (in Asi.iBO.dll) Version: 15.1.2.0

Syntax

C#
public void PrepareCommand(
	SqlCommand command,
	CommandType commandType,
	string sql,
	SqlParameter[] commandParameters
)
Visual Basic (Declaration)
Public Sub PrepareCommand ( _
	command As SqlCommand, _
	commandType As CommandType, _
	sql As String, _
	commandParameters As SqlParameter() _
)
Visual C++
public:
void PrepareCommand(
	SqlCommand^ command, 
	CommandType commandType, 
	String^ sql, 
	array<SqlParameter^>^ commandParameters
)

Parameters

command
Type: System.Data.SqlClient..::.SqlCommand
The SqlCommand to use to execute the SQL. Hold on to this to use repetatively
commandType
Type: System.Data..::.CommandType
The type of cammand contained in the sql parameter.
sql
Type: System..::.String
The SQL command to execute
commandParameters
Type: array< System.Data.SqlClient..::.SqlParameter >[]()[]
The parameters to be bound to the query

See Also