Ready to get started?

Learn more about the CData ADO.NET Provider for OFX or download a free trial:

Download Now

DataBind OFX Data to the DevExpress Data Grid

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

The CData ADO.NET Provider for OFX 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 OFXUser and OFXPassword properties, under the Authentication section, must be set to valid OFX user credentials. In addition to this, you will need to configure FIURL, FIOrganizationName, and FIID, which will be specific for the financial institution. You will also need to provide application-specific settings, including OFXVersion, ApplicationVersion, and ApplicationId.

To connect to some services, you will need to provide additional account information such as AccountId, AccountType, BankId, BrokerId, and CCNumber.

Windows Forms Controls

The code below shows how to populate a DevExpress chart with OFX data. The OFXDataAdapter 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 (OFXConnection connection = new OFXConnection( "OFXUser=myUser;OFXPassword=myPassword;FIID=myFIID;")) { OFXDataAdapter dataAdapter = new OFXDataAdapter( "SELECT Id, Amount FROM InvBalances", 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[] { "Amount" }); series.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; series.ArgumentDataMember = "Id"; 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 OFX data. The OFXDataAdapter 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 (OFXConnection connection = new OFXConnection( "OFXUser=myUser;OFXPassword=myPassword;FIID=myFIID;")) { OFXDataAdapter OFXDataAdapter1 = new OFXDataAdapter("SELECT Id, Amount FROM InvBalances", connection); DataTable table = new DataTable(); OFXDataAdapter1.Fill(table); DevExpress.XtraCharts.Series series = new Series("Series1", ViewType.Bar); WebChartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "Amount" }); series.ArgumentScaleType = ScaleType.Qualitative; series.ArgumentDataMember = "Id"; series.ValueScaleType = ScaleType.Numerical; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }
 
 
ダウンロード