Item(Int32) Property

Gets the value of the specified field (column) as an Object.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Overloads Overrides NotOverridable ReadOnly Property Item( _
   ByVal ordinal As Integer _
) As Object

'Usage
 
Dim instance As TdDataReader
Dim ordinal As Integer
Dim value As Object
 
value = instance.Item(ordinal)

public override object Item( 
   int ordinal
) {get;}

public:
property Object^ Item {
   Object^ get(int ordinal) override;
}

Parameters

ordinal: Column ordinal (see TdDataReader.GetOrdinal).

Property Value

The value of the specified field represented as a System.Object type.

Exceptions

Exception	Description
System.IndexOutOfRangeException	ordinal is less than zero or ordinal is equal to or greater than TdDataReader.FieldCount.
System.InvalidOperationException	CommandBehavior is set to SchemaOnly, or there is no data for the row or column, or preceding columns are no longer accessible.
System.ObjectDisposedException	The TdDataReader is closed.
TdException	The Advanced SQL Engine returned an error or .NET Data Provider for Teradata detected an error.

Remarks

Item returns a System.Object that is the root of all types. It is used to retrieve any Teradata data type. The .NET Data Provider for Teradata maps the Teradata data types to .NET Framework types and returns a reference to the .NET Framework instance.

Item is the most flexible field retrieval method, but is also the slowest field retrieval method. It is strongly recommended that to use the other strongly typed field retrieval methods (for example, GetInt32).

This method does not throw an exception for null database fields. It returns an instance of DBNull.

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

Reference

TdDataReader Class
TdDataReader Members
Overload List