Binds the supplied parameters to the supplied command and executes the command. The command must have been prepared with a call to PrepareCommand(SqlCommand, CommandType, String, array<SqlParameter>[]()[][]). This method can then be called in a loop with different parameters to save the prepare time when the same statement is executed over and over.

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

Syntax

C#
public static void BindAndExecute(
	SqlCommand command,
	SqlParameter[] commandParameters
)
Visual Basic
Public Shared Sub BindAndExecute ( _
	command As SqlCommand, _
	commandParameters As SqlParameter() _
)
Visual C++
public:
static void BindAndExecute(
	SqlCommand^ command, 
	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
commandParameters
Type: array<System.Data.SqlClient..::..SqlParameter>[]()[][]
The parameters to be bound to the query

See Also