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.2.0

Syntax

C#
public static void BindAndExecute(
	SqlCommand command,
	SqlParameter[] commandParameters
)
Visual Basic (Declaration)
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