SqlDataReader.GetSqlXml(Int32) Method

Reference

Definition

Namespace:: Microsoft.Data.SqlClient

Assembly:: Microsoft.Data.SqlClient.dll

Package:: Microsoft.Data.SqlClient v1.0.19269.1

Package:: Microsoft.Data.SqlClient v1.1.4

Package:: Microsoft.Data.SqlClient v2.0.1

Package:: Microsoft.Data.SqlClient v2.1.4

Package:: Microsoft.Data.SqlClient v3.0.1

Package:: Microsoft.Data.SqlClient v3.1.0

Package:: Microsoft.Data.SqlClient v4.0.1

Package:: Microsoft.Data.SqlClient v4.1.0

Package:: Microsoft.Data.SqlClient v5.0.0

Package:: Microsoft.Data.SqlClient v5.1.0

Package:: Microsoft.Data.SqlClient v5.2.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 virtual System::Data::SqlTypes::SqlXml ^ GetSqlXml(int i);

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

abstract member GetSqlXml : int -> System.Data.SqlTypes.SqlXml
override this.GetSqlXml : int -> System.Data.SqlTypes.SqlXml

Public Overridable Function GetSqlXml (i As Integer) As SqlXml

Parameters

i: Int32

The zero-based column ordinal.

Returns

SqlXml

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

Exceptions

ArgumentOutOfRangeException

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

InvalidOperationException

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

InvalidCastException

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

Share via