Returns a specific subset of rows when paging through the results of a query.
The example below shows how to retrieve a part of a table. If this function is called with parameters
startRecord=2 and
maxRecords=3, it returns 3 rows: second, third, and fourth.
public void ExecutePaged(SalesforceConnection salesforceConnection, int StartRow, int PageLength)
{
SalesforceCommand salesforceCommand = new SalesforceCommand("SELECT Id, Name, Type FROM Account", salesforceConnection);
salesforceConnection.Open();
SalesforceDataReader salesforceReader = salesforceCommand.ExecutePageReader(System.Data.CommandBehavior.Default,StartRow,PageLength);
try
{
while (salesforceReader.Read())
{
Console.WriteLine(salesforceReader.GetString(0) + ", " + salesforceReader.GetString(1) + ", " + salesforceReader.GetString(2));
}
}
finally
{
salesforceReader.Close();
salesforceConnection.Close();
}
}
Public Sub ExecutePaged(ByVal salesforceConnection As SalesforceConnection, ByVal StartRow As Integer, ByVal PageLength As Integer)
Dim salesforceCommand As New SalesforceCommand("SELECT Id, Name, Type FROM Account", salesforceConnection)
salesforceConnection.Open()
Dim salesforceReader As SalesforceDataReader = salesforceCommand.ExecutePageReader(System.Data.CommandBehavior.Default, StartRow, PageLength)
Try
While salesforceReader.Read()
Console.WriteLine(salesforceReader.GetString(0) + ", " _
+ salesforceReader.GetString(1) + ", " _
+ salesforceReader.GetString(2))
End While
Finally
salesforceReader.Close()
salesforceConnection.Close()
End Try
End Sub