Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
GetSqlFieldType Method
Collapse the table of content
Expand the table of content

SqlDataRecord.GetSqlFieldType Method

Returns a Type object that represents the type (as a SQL Server type, defined in System.Data.SqlTypes) that maps to the SQL Server type of the column.

Namespace:  Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public virtual Type GetSqlFieldType(
	int ordinal
)

Parameters

ordinal
Type: System.Int32

The zero-based ordinal of the column.

Return Value

Type: System.Type
The column type as a Type object.

ExceptionCondition
IndexOutOfRangeException

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

TypeLoadException

The column is of a user-defined type that is not available to the calling application domain.

FileNotFoundException

The column is of a user-defined type that is not available to the calling application domain.

InvalidCastException

There is a type mismatch.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft