Item(String) Property

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overrides ReadOnly Property Item( _
   ByVal name As String _
) As Object

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

Parameters

name: The column name.

Property Value

The value of the specified column in its native format.

Remarks

You can omit the property name.

Example

csharp

static void GetHireDate(OracleConnection myConnection) {
  OracleCommand cmd = new OracleCommand("SELECT * FROM Test.emp");
  cmd.Connection = myConnection;
  myConnection.Open();
  try {
    OracleDataReader reader = cmd.ExecuteReader();
    reader.Read();
        DateTime recievedTime = (DateTime)reader["hiredate"];
    reader.Close();
  }
  finally {
    myConnection.Close();
  }
}

Visual Basic

Shared Sub GetHireDate(ByVal myConnection As OracleConnection)
  Dim cmd As New OracleCommand("SELECT * FROM Test.emp")
  cmd.Connection = myConnection
  myConnection.Open()
  Try
    Dim reader As OracleDataReader = cmd.ExecuteReader
    reader.Read()
    Dim recievedTime As DateTime = CDate(reader("hiredate"))
    reader.Close()
  Finally
    myConnection.Close()
  End Try
End Sub

Reference

DbDataReaderBase Class
DbDataReaderBase Members
Overload List

Send Feedback