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.

Example

csharp

static void GetMyValues(ExactTargetConnection myConnection) {
  ExactTargetCommand cmd = new ExactTargetCommand("SELECT * FROM Email");
  cmd.Connection = myConnection;
  myConnection.Open();
  try
  {
    ExactTargetDataReader 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 ExactTargetConnection)
  Dim cmd As New ExactTargetCommand("SELECT * FROM Email")
  cmd.Connection = myConnection
  myConnection.Open()
  Try
    Dim reader As ExactTargetDataReader = 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

Reference

SqlShimDataReader Class
SqlShimDataReader Members

Send Feedback