原創|使用教程|編輯:我只采一朵|2014-01-26 09:43:10.000|閱讀 3351 次
概述:本文以圖表和網格為例介紹如何DevExpress Dashboard的儀表盤控件項目綁定到數據庫中。
# 界面/圖表報表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
相關鏈接:
上一講介紹了如何設置 DevExpress Dashboard 的儀表盤參數,那么接下來我們就可以將一些儀表盤控件綁定到數據庫中了,下面我以圖表(Chart) 和網格(Grid) 兩個控件為例跟大家展示一下。
如何將Chart儀表盤項目綁定到數據庫:
using System; using System.Windows.Forms; using DevExpress.DashboardCommon; using DevExpress.DataAccess; namespace Dashboard_CreateChart { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private ChartDashboardItem CreateChart(DataSource dataSource) { // Creates a chart dashboard item and specifies its data source. ChartDashboardItem chart = new ChartDashboardItem(); chart.DataSource = dataSource; // Specifies the dimension used to provide data for arguments on a chart. chart.Arguments.Add(new Dimension("Sales Person", DateTimeGroupInterval.Year)); // Specifies the dimension that provides data for chart series. chart.SeriesDimensions.Add(new Dimension("OrderDate")); // Adds a new chart pane to the chart's Panes collection. chart.Panes.Add(new ChartPane()); // Creates a new series of the Bar type. SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Bar); // Specifies the measure that provides data used to calculate // the Y-coordinate of data points. salesAmountSeries.Value = new Measure("Extended Price"); // Adds created series to the pane's Series collection to display within this pane. chart.Panes[0].Series.Add(salesAmountSeries); chart.Panes.Add(new ChartPane()); SimpleSeries taxesAmountSeries = new SimpleSeries(SimpleSeriesType.StackedBar); taxesAmountSeries.Value = new Measure("Quantity"); chart.Panes[1].Series.Add(taxesAmountSeries); return chart; } private void Form1_Load(object sender, EventArgs e) { // Creates a dashboard and sets it as the currently opened dashboard in the dashboard viewer. dashboardViewer1.Dashboard = new Dashboard(); // Creates a data source and adds it to the dashboard data source collection. DataSource dataSource = new DataSource("Sales Person"); dashboardViewer1.Dashboard.DataSources.Add(dataSource); // Creates a chart dashboard item with the specified data source // and adds it to the Items collection to display within the dashboard. ChartDashboardItem chart = CreateChart(dataSource); dashboardViewer1.Dashboard.Items.Add(chart); // Reloads data in the data sources. dashboardViewer1.ReloadData(); } private void dashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { // Specifies data for the current data source. e.Data = (new nwindDataSetTableAdapters.SalesPersonTableAdapter()).GetData(); } } }
如何將Grid儀表盤項目綁定到數據庫:
using System; using System.Windows.Forms; using DevExpress.DashboardCommon; using DevExpress.DataAccess; namespace Dashboard_CreateGrid { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private GridDashboardItem CreateGrid(DataSource dataSource) { // Creates a grid dashboard item and specifies its data source. GridDashboardItem grid = new GridDashboardItem(); grid.DataSource = dataSource; // Creates new grid columns of the specified type and with the specified dimension or // measure. Then, adds these columns to the grid's Columns collection. grid.Columns.Add(new GridDimensionColumn(new Dimension("Sales Person"))); grid.Columns.Add(new GridDimensionColumn(new Dimension("OrderDate", DateTimeGroupInterval.QuarterYear))); grid.Columns.Add(new GridMeasureColumn(new Measure("Extended Price"))); // Allows merging adjacent cells with identical values. grid.GridOptions.AllowCellMerge = true; return grid; } private void Form1_Load(object sender, EventArgs e) { // Creates a dashboard and sets it as the currently opened dashboard in the dashboard viewer. dashboardViewer1.Dashboard = new Dashboard(); // Creates a data source and adds it to the dashboard data source collection. DataSource dataSource = new DataSource("Sales Person"); dashboardViewer1.Dashboard.DataSources.Add(dataSource); // Creates a grid dashboard item with the specified data source // and adds it to the Items collection to display within the dashboard. GridDashboardItem grid = CreateGrid(dataSource); dashboardViewer1.Dashboard.Items.Add(grid); // Reloads data in the data sources. dashboardViewer1.ReloadData(); } private void dashboardViewer1_DataLoading(object sender, DataLoadingEventArgs e) { // Specifies data for the current data source. e.Data = (new nwindDataSetTableAdapters.SalesPersonTableAdapter()).GetData(); } } }
本站文章除注明轉載外,均為本站原創或翻譯。歡迎任何形式的轉載,但請務必注明出處、不得修改原文相關鏈接,如果存在內容上的異議請郵件反饋至chenjj@fc6vip.cn
文章轉載自:慧都控件