EndExecuteXmlReader Method

SqlCommand.EndExecuteXmlReader Method (IAsyncResult)


Finishes asynchronous execution of a Transact-SQL statement, returning the requested data as XML.

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

public XmlReader EndExecuteXmlReader(
	IAsyncResult asyncResult


Type: System.IAsyncResult

The IAsyncResult returned by the call to BeginExecuteXmlReader.

Return Value

Type: System.Xml.XmlReader

An XmlReader object that can be used to fetch the resulting XML data.

Exception Condition

asyncResult parameter is null (Nothing in Microsoft Visual Basic)


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

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

For examples demonstrating the use of the EndExecuteXmlReader method, see BeginExecuteXmlReader.

.NET Framework
Available since 2.0
Return to top
© 2015 Microsoft