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

Using the Sage50UKDataAdapter

Use the adapter's Fill method to retrieve data from the data source. An empty DataTable instance is passed as an argument to the Fill method. When the method returns, the DataTable instance is populated with the queried data. Note that the Sage50UKDataAdapter is slower than the Sage50UKDataReader because the Fill method needs to retrieve all data from the data source before returning.

The following example selects the TradingAccountUUID and Name columns of the TradingAccounts table:

C#

string connectionString = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;";

using (Sage50UKConnection connection = new Sage50UKConnection(connectionString)) {
  Sage50UKDataAdapter dataAdapter = new Sage50UKDataAdapter(
  "SELECT TradingAccountUUID, Name FROM TradingAccounts", connection);

  DataTable table = new DataTable();
  dataAdapter.Fill(table);

  Console.WriteLine("Contents of TradingAccounts.");

  foreach (DataRow row in table.Rows) {
    Console.WriteLine("{0}: {1}", row["TradingAccountUUID"], row["Name"]);
  }
}

VB.NET

Dim connectionString As String = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;"

Using connection As New Sage50UKConnection(connectionString)
  Dim dataAdapter As New Sage50UKDataAdapter("SELECT TradingAccountUUID, Name FROM TradingAccounts", connection)

  Dim table As New DataTable()
  dataAdapter.Fill(table)

  Console.WriteLine("Contents of TradingAccounts.")

  For Each row As DataRow In table.Rows
    Console.WriteLine("{0}: {1}", row("TradingAccountUUID"), row("Name"))
  Next
End Using