This topic has not yet been rated - Rate this topic

SqlCeDataReader.GetOrdinal Method

Visual Studio 2010

Other Versions

Gets the column ordinal, given the name of the column.

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

Syntax

C++

JScript

Copy

public override int GetOrdinal(
	string name
)

Parameters

name: Type: System.String
The name of the column.

Return Value

Type: System.Int32
The zero-based column ordinal.

Implements

IDataRecord.GetOrdinal(String)

Exceptions

Exception	Condition
IndexOutOfRangeException	The name specified is not a valid column name.
InvalidOperationException	The operation is not valid. The SqlCeDataReader may be positioned after the last row in the result set.

Remarks

GetOrdinal performs a case-sensitive lookup first. If it fails, a second case-insensitive search is made.

Because ordinal-based lookups are more efficient than named lookups, it is inefficient to call GetOrdinal within a loop. Save time by calling GetOrdinal once and assigning the results to an integer variable for use within the loop.

Reference

SqlCeDataReader Class

System.Data.SqlServerCe Namespace

GetName

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)