SqlDataReader.GetSqlXml Method (Int32)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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

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

abstract GetSqlXml : 
        i:int -> SqlXml
override GetSqlXml : 
        i:int -> SqlXml


Type: System.Int32

The zero-based column ordinal.

Return Value

Type: System.Data.SqlTypes.SqlXml

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

Exception Condition

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.

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.

.NET Framework
Available since 2.0
Return to top