SqlDataReader.GetSqlXml(Int32) Method

Definition

Gets the value of the specified column as an XML value.

C#
public virtual System.Data.SqlTypes.SqlXml GetSqlXml (int i);

Parameters

i
Int32

The zero-based column ordinal.

Returns

A SqlXml value that contains the XML stored within the corresponding field.

Exceptions

The index passed was outside the range of 0 to FieldCount - 1

An attempt was made to read or access columns in a closed SqlDataReader.

The retrieved data is not compatible with the SqlXml type.

Remarks

No conversions are performed; therefore, the data retrieved must already be an XML value.

Call IsDBNull to check for null values before calling this method.

Applies to

Product Versions
SqlClient .NET Core 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2
SqlClient .NET Framework 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2
SqlClient .NET Standard 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2