GetProviderSpecificFieldType(Int32) Method

In This Topic

Gets the System.Type that is the provider-specific data type of the object.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overrides Function GetProviderSpecificFieldType( _
   ByVal i As Integer _
) As Type

public override Type GetProviderSpecificFieldType( 
   int i
)

Parameters

i

Return Value

The System.Type that is the provider-specific data type of the object.

Example

csharp

static void GetMyFieldType(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++) {
      object someValue = reader.GetProviderSpecificValue(i);
      Console.Write(reader.GetProviderSpecificFieldType(i).FullName + " : ");
      Console.WriteLine(someValue.ToString());
    }

    reader.Close();
  }
  finally {
    myConnection.Close();
  }
}

Visual Basic

Shared Sub GetMyFieldType(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
      Dim someValue As Object = reader.GetProviderSpecificValue(i)
      Console.Write((reader.GetProviderSpecificFieldType(i).FullName & " : "))
      Console.WriteLine(someValue.ToString)
    Next i
    reader.Close()
  Finally
    myConnection.Close()
  End Try
End Sub

Reference

OracleDataReader Class
OracleDataReader Members
Overload List

Send Feedback