今すぐお試しください!

製品の詳細CData ADO.NET Provider for Dynamics AX を確認して、無償評価版をダウンロード:

今すぐダウンロード

DataBind Dynamics AX Data to the DevExpress Data Grid

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

The CData ADO.NET Provider for Dynamics AX 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.

To connect to DynamicsAX, specify User, Domain, and ObjectServer. You can also surface tables for a specific Company; when this property is blank, the default company is used.

Alternatively, you can use the .NET Business Connector to connect on behalf of DynamicsAX users. You can obtain the ProxyUser and ProxyDomain properties on the System service accounts form: Click System Administration -> Setup -> System -> System Service Accounts. Additionally, set ProxyPassword.

By default, only transaction data and base information from the TRANSACTION and MAIN table groups is returned. You can specify which groups to return with TableGroups.

Set Language to use the same language you use in your DynamicsAX labels.

Windows Forms Controls

The code below shows how to populate a DevExpress chart with Dynamics AX data. The DynamicsAXDataAdapter 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 (DynamicsAXConnection connection = new DynamicsAXConnection( "User=MyUser;Domain=MyDomain;objectserver=MicrosoftDynamicsAX@WIN-1IP52JPQVJS:2712;")) { DynamicsAXDataAdapter dataAdapter = new DynamicsAXDataAdapter( "SELECT Name, Qty FROM CustInvoiceTrans", 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[] { "Qty" }); 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 Dynamics AX data. The DynamicsAXDataAdapter 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 (DynamicsAXConnection connection = new DynamicsAXConnection( "User=MyUser;Domain=MyDomain;objectserver=MicrosoftDynamicsAX@WIN-1IP52JPQVJS:2712;")) { DynamicsAXDataAdapter DynamicsAXDataAdapter1 = new DynamicsAXDataAdapter("SELECT Name, Qty FROM CustInvoiceTrans", connection); DataTable table = new DataTable(); DynamicsAXDataAdapter1.Fill(table); DevExpress.XtraCharts.Series series = new Series("Series1", ViewType.Bar); WebChartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "Qty" }); series.ArgumentScaleType = ScaleType.Qualitative; series.ArgumentDataMember = "Name"; series.ValueScaleType = ScaleType.Numerical; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }
 
 
ダウンロード