SqlCeDataReader.GetOrdinal Method

Article
10/22/2007

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

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Overrides Function GetOrdinal ( _
    name As String _
) As Integer
'Usage
Dim instance As SqlCeDataReader
Dim name As String
Dim returnValue As Integer

returnValue = instance.GetOrdinal(name)

public override int GetOrdinal (
    string name
)

public:
virtual int GetOrdinal (
    String^ name
) override

public int GetOrdinal (
    String name
)

public override function GetOrdinal (
    name : String
) : int

Parameters

name
The name of the column.

Return Value

The zero-based column ordinal.

Exceptions

Exception type	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.

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

Version Information

.NET Compact Framework

Supported in: 2.0, 1.0

Share via