GetProviderSpecificValues Method

In This Topic

Gets all column values for the current row. If possible, a provider-specific type is used.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides Function GetProviderSpecificValues( _
   ByVal values() As Object _
) As Integer

public override int GetProviderSpecificValues( 
   object[] values
)

Parameters

values: An array of System.Object into which to copy the column values.

Return Value

The number of instances of System.Object in the array.

Remarks

This method is equivalent to the GetValues method, the only difference is that this method uses a provider-specific type whenever possible.

Example

csharp

static void GetMyValues(PgSqlConnection myConnection) {
  PgSqlCommand cmd = new PgSqlCommand("SELECT * FROM Test.Dept");
  cmd.Connection = myConnection;
  myConnection.Open();
  try
  {
    PgSqlDataReader reader = cmd.ExecuteReader();
    reader.Read();

    object[] someValues = new object[5];
    int number = reader.GetProviderSpecificValues(someValues);

    for (short i = 0; i < number; i++)
    {
      Console.WriteLine(someValues[i].ToString());
    }

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

Visual Basic

Shared Sub GetMyValues(ByVal myConnection As PgSqlConnection)
  Dim cmd As New PgSqlCommand("SELECT * FROM Test.Dept")
  cmd.Connection = myConnection
  myConnection.Open()
  Try
    Dim reader As PgSqlDataReader = cmd.ExecuteReader
    reader.Read()
    Dim someValues As Object() = New Object() {}
    Dim number As Integer = reader.GetProviderSpecificValues(someValues)
    For i As Short = 0 To number - 1
      Console.WriteLine(someValues(i).ToString)
    Next i
    reader.Close()
  Finally
    myConnection.Close()
  End Try
End Sub

Reference

PgSqlDataReader Class
PgSqlDataReader Members

Send Feedback