SqlHelper.ExecuteNonQuery Method (SqlTransaction, CommandType, String)

Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlTransaction.

[Visual Basic]
Overloads Public Shared Function ExecuteNonQuery( _
   ByVal transaction As SqlTransaction, _
   ByVal commandType As CommandType, _
   ByVal commandText As String _
) As Integer

[C#]
public static int ExecuteNonQuery(
   SqlTransaction transaction,
   CommandType commandType,
   string commandText
);

Parameters

transaction: a valid SqlTransaction
commandType: the CommandType (stored procedure, text, etc.)
commandText: the stored procedure name or T-SQL command

Return Value

an int representing the number of rows affected by the command

Remarks

e.g.: int result = ExecuteNonQuery(trans, CommandType.StoredProcedure, "PublishOrders");

SqlHelper.ExecuteNonQuery Method (SqlTransaction, CommandType, String)

Parameters

Return Value

Remarks

See Also