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

Using the MYOBDataReader

The MYOBDataReader retrieves data faster than the MYOBDataAdapter because it can retrieve data in pages. As you read data from the MYOBDataReader, 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 Accounts table:

C#

string connectionString = " If using an online instance: InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CompanyFileId=yourCompanyFileId;CallbackURL=http://localhost:33333;User=companyFileUser;Password=companyFilePassword; If using an on premise instance: InitiateOAuth=OFF;URL=http://localhost:8080/accountright;CompanyFileId=327eed10-9615-4e5e-bd9e-ae2cc00e2c70;User=companyFileUser;Password=companyFilePassword;";

using (MYOBConnection connection = new MYOBConnection(connectionString)) {
  MYOBCommand cmd = new MYOBCommand("SELECT * FROM Accounts", connection);
  
  MYOBDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = " If using an online instance: InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CompanyFileId=yourCompanyFileId;CallbackURL=http://localhost:33333;User=companyFileUser;Password=companyFilePassword; If using an on premise instance: InitiateOAuth=OFF;URL=http://localhost:8080/accountright;CompanyFileId=327eed10-9615-4e5e-bd9e-ae2cc00e2c70;User=companyFileUser;Password=companyFilePassword;"

Using connection As New MYOBConnection(connectionString)
  Dim cmd As New MYOBCommand("SELECT * FROM Accounts", connection)

  Dim rdr As MYOBDataReader = cmd.ExecuteReader()

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