dotConnect for Zoho Books Documentation
Devart.Data Namespace / SqlShimDataReader Class / GetProviderSpecificValues Method
An array of System.Object into which to copy the column values.
Example

In This Topic
    GetProviderSpecificValues Method
    In This Topic
    Gets all column values for the current row. If possible, a provider-specific type is used.
    Syntax
    '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.
    Example
    static void GetMyValues(ZohoBooksConnection myConnection) {
      ZohoBooksCommand cmd = new ZohoBooksCommand("SELECT * FROM Accounts");
      cmd.Connection = myConnection;
      myConnection.Open();
      try
      {
        ZohoBooksDataReader 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();
      }
    }
    Shared Sub GetMyValues(ByVal myConnection As ZohoBooksConnection)
      Dim cmd As New ZohoBooksCommand("SELECT * FROM Accounts")
      cmd.Connection = myConnection
      myConnection.Open()
      Try
        Dim reader As ZohoBooksDataReader = 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
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also