Item(String) 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 name As String _
) As Object

'Usage
 
Dim instance As TdDataReader
Dim name As String
Dim value As Object
 
value = instance.Item(name)

public override object Item( 
   string name
) {get;}

public:
property Object^ Item {
   Object^ get(String^ name) override;
}

Parameters

name: Specifies the column name.

Property Value

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

Exceptions

Exception	Description
System.IndexOutOfRangeException	No column with the specified name was found.
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 an Object reference.

Item is the most flexible field retrieval method, but is also the slowest field retrieval method. It is strongly recommended 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