The CData ADO.NET Provider for TSheets implements two ADO.NET interfaces you can use to retrieve data from TSheets: TSheetsDataAdapter and TSheetsDataReader objects. Whereas TSheetsDataAdapter objects retrieve a single result set of all the data that matches a query, TSheetsDataReader objects fetch data in subset increments as needed.

Using the TSheetsDataReader

The TSheetsDataReader retrieves data faster than the TSheetsDataAdapter because it can retrieve data in pages. As you read data from the TSheetsDataReader, it periodically requests the next page of results from the data source, if required. This causes results to be returned at a faster rate. The following example selects all the columns from the Timesheets table:

C#

string connectionString = "OAuthClientId=myclientid;OAuthClientSecret=myclientsecret;InitiateOAuth=GETANDREFRESH;CallbackUrl=http://localhost:33333;";

using (TSheetsConnection connection = new TSheetsConnection(connectionString)) {
  TSheetsCommand cmd = new TSheetsCommand("SELECT * FROM Timesheets", connection);
  
  TSheetsDataReader rdr = cmd.ExecuteReader();

  while (rdr.Read()) {
    Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["Id"], rdr["JobcodeId"]));
  }
}

VB.NET

Dim connectionString As String = "OAuthClientId=myclientid;OAuthClientSecret=myclientsecret;InitiateOAuth=GETANDREFRESH;CallbackUrl=http://localhost:33333;"

Using connection As New TSheetsConnection(connectionString)
  Dim cmd As New TSheetsCommand("SELECT * FROM Timesheets", connection)

  Dim rdr As TSheetsDataReader = cmd.ExecuteReader()

  While rdr.Read()
    Console.WriteLine([String].Format(vbTab & "{0} --> " & vbTab & vbTab & "{1}", rdr("Id"), rdr("JobcodeId")))
  End While
End Using