A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqldatareader.getxmlreader below:

SqlDataReader.GetXmlReader(Int32) Method (System.Data.SqlClient) | Microsoft Learn

SqlDataReader.GetXmlReader(Int32) Method Definition
public:
 virtual System::Xml::XmlReader ^ GetXmlReader(int i);
public virtual System.Xml.XmlReader GetXmlReader(int i);
abstract member GetXmlReader : int -> System.Xml.XmlReader
override this.GetXmlReader : int -> System.Xml.XmlReader
Public Overridable Function GetXmlReader (i As Integer) As XmlReader
Parameters
i
Int32

The value of the specified column.

Returns

The returned object.

Exceptions

The connection drops or is closed during the data retrieval.

The SqlDataReader is closed during the data retrieval.

There is no data ready to be read (for example, the first Read() hasn't been called, or returned false).

Trying to read a previously read column in sequential mode.

There was an asynchronous operation in progress. This applies to all Get* methods when running in sequential mode, as they could be called while reading a stream.

Trying to read a column that does not exist.

The returned type was not xml.

Remarks

The XmlReader object returned by GetXmlReader does not support asynchronous operations. If you require asynchronous operations on an XmlReader, cast the XML column to an NVARCHAR(MAX) on the server and use GetTextReader with Create.

SqlException exceptions raised from XmlReader are thrown as XmlException exceptions; check the inner exception for the SqlException.

GetChars will raise an InvalidOperationException exception when used on an object returned by GetXmlReader when SequentialAccess is in effect.

For more information, see SqlClient Streaming Support.

Collaborate with us on GitHub

The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide. In this article

Was this page helpful?


RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4