SqlCommand.EndExecuteNonQuery Method

Note: This method is new in the .NET Framework version 2.0.

Finishes asynchronous execution of a Transact-SQL statement.

Namespace: System.Data.SqlClient
Assembly: System.Data (in system.data.dll)

public int EndExecuteNonQuery (
	IAsyncResult asyncResult
)
public int EndExecuteNonQuery (
	IAsyncResult asyncResult
)
public function EndExecuteNonQuery (
	asyncResult : IAsyncResult
) : int

Parameters

asyncResult

The IAsyncResult returned by the call to BeginExecuteNonQuery.

Return Value

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

Exception typeCondition

ArgumentException

asyncResult parameter is null (Nothing in Microsoft Visual Basic)

InvalidOperationException

EndExecuteNonQuery was called more than once for a single command execution, or the method was mismatched against its execution method (for example, the code called EndExecuteNonQuery to complete execution of a call to BeginExecuteXmlReader.

When you call BeginExecuteNonQuery to execute a Transact-SQL statement, you must call EndExecuteNonQuery 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 BeginExecuteNonQuery method. If a callback procedure was specified in the call to BeginExecuteNonQuery, this method must be called.

For examples demonstrating the use of the EndExecuteNonQuery method, see BeginExecuteNonQuery and BeginExecuteNonQuery.

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0

Community Additions

ADD
Show: