SqlDataRecord.GetSqlValue(Int32) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Server

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.dll

Package:: System.Data.SqlClient v4.8.5

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.

Returns the data value stored in the column, expressed as a SQL Server type, specified by the column ordinal.

public:
 virtual System::Object ^ GetSqlValue(int ordinal);

public virtual object GetSqlValue (int ordinal);

abstract member GetSqlValue : int -> obj
override this.GetSqlValue : int -> obj

Public Overridable Function GetSqlValue (ordinal As Integer) As Object

Parameters

ordinal: Int32

The zero-based ordinal of the column.

Returns

Object

The value of the column, expressed as a SQL Server type, as a Object.

Exceptions

IndexOutOfRangeException

The ordinal is less than 0 or greater than the number of columns (that is, FieldCount).

InvalidCastException

There is a type mismatch.

Remarks

For null values, a SQL Server type instance is returned where the IsNull property is true.

Applies to