Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

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
)

Parameters

asyncResult
Type: System::IAsyncResult

The IAsyncResult returned by the call to BeginExecuteReader.

Return Value

Type: System.Data.SqlClient::SqlDataReader
A SqlDataReader object that can be used to retrieve the requested rows.
ExceptionCondition
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.

.NET Framework

Supported in: 4.5.1, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows Phone 8.1, Windows Phone 8, Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.