Ready to get started?

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

Download Now

DataBind AWS Management Data to the DevExpress Data Grid

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

The CData ADO.NET Provider for AWS Management 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 authorize AWSDataManagement requests, provide the credentials for an administrator account or for an IAM user with custom permissions:

  1. Set AccessKey to the access key Id.
  2. Set SecretKey to the secret access key.
  3. Set Region to the region where your AWSDataManagement data is hosted.

Note: Though you can connect as the AWS account administrator, it is recommended to use IAM user credentials to access AWS services.

Windows Forms Controls

The code below shows how to populate a DevExpress chart with AWS Management data. The AWSDataManagementDataAdapter 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 (AWSDataManagementConnection connection = new AWSDataManagementConnection( "AccessKey=myAccessKey;Account=myAccountName;Region=us-east-1;")) { AWSDataManagementDataAdapter dataAdapter = new AWSDataManagementDataAdapter( "SELECT PartitionKey, Name FROM NorthwingProducts", 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[] { "Name" }); series.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; series.ArgumentDataMember = "PartitionKey"; 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 AWS Management data. The AWSDataManagementDataAdapter 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 (AWSDataManagementConnection connection = new AWSDataManagementConnection( "AccessKey=myAccessKey;Account=myAccountName;Region=us-east-1;")) { AWSDataManagementDataAdapter AWSDataManagementDataAdapter1 = new AWSDataManagementDataAdapter("SELECT PartitionKey, Name FROM NorthwingProducts", connection); DataTable table = new DataTable(); AWSDataManagementDataAdapter1.Fill(table); DevExpress.XtraCharts.Series series = new Series("Series1", ViewType.Bar); WebChartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "Name" }); series.ArgumentScaleType = ScaleType.Qualitative; series.ArgumentDataMember = "PartitionKey"; series.ValueScaleType = ScaleType.Numerical; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }
 
 
ダウンロード