System.Data.SqlClient.SqlCommand.EndExecuteNonQuery Method

Finishes asynchronous execution of a Transact-SQL statement.

Syntax

public int EndExecuteNonQuery (IAsyncResult asyncResult)

Parameters

asyncResult
The IAsyncResult returned by the call to SqlCommand.BeginExecuteNonQuery.

Returns

The number of rows affected (the same behavior as SqlCommand.ExecuteNonQuery).

Remarks

When you call erload:System.Data.SqlClient.SqlCommand.BeginExecuteNonQuery to execute a tsql statement, you must call SqlCommand.EndExecuteNonQuery(IAsyncResult) in order to complete the operation. If the process of executing the command has not yet finished, this method blocks until the operation is complete. Users can verify that the command has completed its operation by using the IAsyncResult instance returned by the SqlCommand.BeginExecuteNonQuery method. If a callback procedure was specified in the call to SqlCommand.BeginExecuteNonQuery, this method must be called.

Requirements

Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 2.0.0.0