Export (0) Print
Expand All

SqlCommand.EndExecuteReader Method

Finishes asynchronous execution of a Transact-SQL statement, returning the requested SqlDataReader.

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

public SqlDataReader EndExecuteReader (
	IAsyncResult asyncResult
)
public SqlDataReader EndExecuteReader (
	IAsyncResult asyncResult
)
public function EndExecuteReader (
	asyncResult : IAsyncResult
) : SqlDataReader
Not applicable.

Parameters

asyncResult

The IAsyncResult returned by the call to BeginExecuteReader.

Return Value

A SqlDataReader object that can be used to retrieve the requested rows.

Exception typeCondition

ArgumentException

asyncResult parameter is null (Nothing in Microsoft Visual Basic)

InvalidOperationException

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

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

For examples demonstrating the use of the EndExecuteReader method, see BeginExecuteReader.

Windows 98, Windows Server 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 Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

Community Additions

ADD
Show:
© 2014 Microsoft