This topic has not yet been rated - Rate this topic

SqlCommand.EndExecuteReader Method

.NET Framework 2.0

Other Versions

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

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

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

Syntax

C++

Copy

public SqlDataReader EndExecuteReader (
	IAsyncResult asyncResult
)

Copy

public SqlDataReader EndExecuteReader (
	IAsyncResult asyncResult
)

JScript

Copy

public function EndExecuteReader (
	asyncResult : IAsyncResult
) : SqlDataReader

Parameters

asyncResult: The IAsyncResult returned by the call to BeginExecuteReader.

Return Value

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

Exceptions

Exception type	Condition
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.

Remarks

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.

Example

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

Platforms

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.

Version Information

.NET Framework

Supported in: 2.0

Reference

SqlCommand Class
SqlCommand Members
System.Data.SqlClient Namespace

Other Resources

Connecting and Retrieving Data in ADO.NET
Using the .NET Framework Data Provider for SQL Server

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ