Export (0) Print
Expand All

DataTableReader.Item Property (Int32)

Gets the value of the specified column in its native format given the column ordinal.

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

public override Object this [
	int ordinal
] { get; }
/** @property */
public Object get_Item (int ordinal)

Not applicable.

Parameters

ordinal

The zero-based column ordinal.

Property Value

The value of the specified column in its native format.

Exception typeCondition

IndexOutOfRangeException

The index passed was outside the range of 0 to FieldCount - 1.

This overload for Item behaves identically to the GetValue method.

The following example displays the contents of all the columns, in all the rows from the supplied DataTableReader. The code uses the Item method (the indexer, in Microsoft C#) to retrieve the value that is contained in each column.

private static void DisplayItems(DataTableReader reader)
{
    int rowNumber = 0;
    while (reader.Read())
    {
        Console.WriteLine("Row " + rowNumber);
        for (int i = 0; i < reader.FieldCount; i++)
        {
            Console.WriteLine("{0}: {1}", reader.GetName(i), reader[i]);
        }
        rowNumber++;
    }
}

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

.NET Compact Framework

Supported in: 2.0

XNA Framework

Supported in: 1.0

Community Additions

ADD
Show:
© 2014 Microsoft