Read the blog
 

DataBind Reckon Accounts Hosted Data to the DevExpress Data Grid

Ready to get started?

Download a free trial:

Download Now

Learn more:

Reckon Accounts Hosted ADO.NET Provider

Rapidly create and deploy powerful .NET applications that integrate with Reckon Accounts Hosted.

In this article

Related articles


Use the CData ADO.NET Provider for Reckon Accounts Hosted with the DevExpress Windows Forms and Web controls to provide Reckon Accounts Hosted data to a chart.

The CData ADO.NET Provider for Reckon Accounts Hosted implements standard ADO.NET data access components that can be used with third-party controls. The standard ADO.NET process for databinding can be followed to enable bidirectional access to live data from UI controls. In this article we show how to use the CData components to databind to the DevExpress Windows Forms and Web controls; you will databind to a chart that displays current data.

The connector makes requests to Reckon Accounts Hosted through OAuth. Specify the following connection properties:

  • SubscriptionKey: Required. You get this value when you created your developer account.
  • CountryVersion: Defaults to 2021.R2.AU.
  • CompanyFile: Required. The path to the company file.
  • User: Required. The username of the company file.
  • Password: Required. The password of the company file.
  • InitiateOAuth: Set this to GETANDREFRESH to let the driver handle access tokens.
  • CallbackURL: The redirectURI of your Custom OAuth App.
  • OAuthClientId: The client id of your Custom OAuth App.
  • OAuthClientSecret: The client secret of your Custom OAuth App.

CData provides an embedded OAuth application that simplifies OAuth desktop authentication. See the Help documentation for information on other OAuth authentication methods (web, headless, etc.), creating custom OAuth applications, and reasons for doing so.

Windows Forms Controls

The code below shows how to populate a DevExpress chart with Reckon Accounts Hosted data. The ReckonAccountsHostedDataAdapter binds to the Series property of the chart control. The Diagram property of the control defines the x- and y-axes as the column names.

using (ReckonAccountsHostedConnection connection = new ReckonAccountsHostedConnection( "SubscriptionKey=my_subscription_key;CountryVersion=2021.R2.AU;CompanyFile=Q:/CompanyName.QBW;User=my_user;Password=my_password;CallbackURL=http://localhost:33333;OAuthClientId=my_oauth_client_id;OAuthClientSecret=my_oauth_client_secret;InitiateOAuth=GETANDREFRESH")) { ReckonAccountsHostedDataAdapter dataAdapter = new ReckonAccountsHostedDataAdapter( "SELECT Name, Balance FROM Accounts WHERE IsActive = 'true'", connection); DataTable table = new DataTable(); dataAdapter.Fill(table); DevExpress.XtraCharts.Series series = new DevExpress.XtraCharts.Series(); chartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "Balance" }); series.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; series.ArgumentDataMember = "Name"; series.ValueScaleType = DevExpress.XtraCharts.ScaleType.Numerical; chartControl1.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }

Web Controls

The code below shows how to populate a DevExpress Web control with Reckon Accounts Hosted data. The ReckonAccountsHostedDataAdapter binds to the Series property of the chart; the Diagram property defines the x- and y-axes as the column names.

using DevExpress.XtraCharts; using (ReckonAccountsHostedConnection connection = new ReckonAccountsHostedConnection( "SubscriptionKey=my_subscription_key;CountryVersion=2021.R2.AU;CompanyFile=Q:/CompanyName.QBW;User=my_user;Password=my_password;CallbackURL=http://localhost:33333;OAuthClientId=my_oauth_client_id;OAuthClientSecret=my_oauth_client_secret;InitiateOAuth=GETANDREFRESH")) { ReckonAccountsHostedDataAdapter ReckonAccountsHostedDataAdapter1 = new ReckonAccountsHostedDataAdapter("SELECT Name, Balance FROM Accounts WHERE IsActive = 'true'", connection); DataTable table = new DataTable(); ReckonAccountsHostedDataAdapter1.Fill(table); DevExpress.XtraCharts.Series series = new Series("Series1", ViewType.Bar); WebChartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "Balance" }); series.ArgumentScaleType = ScaleType.Qualitative; series.ArgumentDataMember = "Name"; series.ValueScaleType = ScaleType.Numerical; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }