SqlDataRecord.GetSqlValue(Int32) Method

Definition

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

C#
public virtual object GetSqlValue (int ordinal);

Parameters

ordinal
Int32

The zero-based ordinal of the column.

Returns

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

Exceptions

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

There is a type mismatch.

Remarks

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

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

See also