dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleDataReader Class / GetValue Method / GetValue(Int32) Method
Example

In This Topic
    GetValue(Int32) Method
    In This Topic
    Gets the value of the specified column in its native format.
    Syntax
    'Declaration
     
    Public Overloads Overrides Function GetValue( _
       ByVal i As Integer _
    ) As Object
    public override object GetValue( 
       int i
    )

    Parameters

    i

    Return Value

    The value to return.
    Remarks
    This method returns System.DBNull for null data source columns.
    Example
    static void GetMyValue(OracleConnection myConnection)
    {
      OracleCommand cmd = new OracleCommand("SELECT * FROM Test.AllTypes");
      cmd.Connection = myConnection;
      myConnection.Open();
      try
      {
        OracleDataReader reader = cmd.ExecuteReader();
        reader.Read();
    
        for (short i = 0; i < reader.FieldCount; i++)
        {
          if (reader.IsDBNull(i))
            Console.WriteLine("NULL");
          else
          {
            object someValue = reader.GetValue(i);
            Console.WriteLine(someValue.ToString());
          }
        }
    
        reader.Close();
      }
      finally
      {
        myConnection.Close();
      }
    }
    Shared Sub GetMyValue(ByVal myConnection As OracleConnection)
      Dim cmd As New OracleCommand("SELECT * FROM Test.AllTypes")
      cmd.Connection = myConnection
      myConnection.Open()
      Try
        Dim reader As OracleDataReader = cmd.ExecuteReader
        reader.Read()
        For i As Short = 0 To reader.FieldCount - 1
          If reader.IsDBNull(i) Then
            Console.WriteLine("NULL")
          Else
            Console.WriteLine(reader.GetValue(i).ToString)
          End If
        Next i
        reader.Close()
      Finally
        myConnection.Close()
      End Try
    End Sub
    See Also