今すぐお試しください!

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

今すぐダウンロード

DataBind Teradata Data to the DevExpress Data Grid

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

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

Teradata に接続するには、次の認証情報を提供し、データベースサーバー名を指定します。

  • User: Teradata ユーザーのユーザー名に設定。
  • Password: Teradata ユーザーのパスワードに設定。
  • DataSource: Teradata サーバー名、DBC 名、またはTDPID を指定。
  • Port: サーバーが実行されているポートを指定。
  • Database: データベース名を指定。指定されない場合は、本製品 はデフォルトデータベースに接続されます。

Windows Forms Controls

The code below shows how to populate a DevExpress chart with Teradata data. The TeradataDataAdapter 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 (TeradataConnection connection = new TeradataConnection( "User=myuser;Password=mypassword;Server=localhost;Database=mydatabase;")) { TeradataDataAdapter dataAdapter = new TeradataDataAdapter( "SELECT ProductId, ProductName FROM NorthwindProducts WHERE CategoryId = 5", 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[] { "ProductName" }); series.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; series.ArgumentDataMember = "ProductId"; 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 Teradata data. The TeradataDataAdapter 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 (TeradataConnection connection = new TeradataConnection( "User=myuser;Password=mypassword;Server=localhost;Database=mydatabase;")) { TeradataDataAdapter TeradataDataAdapter1 = new TeradataDataAdapter("SELECT ProductId, ProductName FROM NorthwindProducts WHERE CategoryId = 5", connection); DataTable table = new DataTable(); TeradataDataAdapter1.Fill(table); DevExpress.XtraCharts.Series series = new Series("Series1", ViewType.Bar); WebChartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "ProductName" }); series.ArgumentScaleType = ScaleType.Qualitative; series.ArgumentDataMember = "ProductId"; series.ValueScaleType = ScaleType.Numerical; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }
 
 
ダウンロード