How to: Bind a Card Dashboard Item to Data in Code

• Mar 31, 2018
• 3 minutes to read

The following example demonstrates how to bind a Card dashboard item to data in code.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-bind-a-card-dashboard-item-to-data-in-code-e4770.

Form1.cs

using System;
using System.Windows.Forms;
using DevExpress.DashboardCommon;
using DevExpress.DataAccess;

namespace Dashboard_CreateCards {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();
        }
        private CardDashboardItem CreateCards(DashboardObjectDataSource dataSource) {

            // Creates a card dashboard item and specifies its data source.
            CardDashboardItem cards = new CardDashboardItem();
            cards.DataSource = dataSource;

            // Creates a Card object with measures that provide data for calculating the actual and
            // target values. Then, adds this object to the Cards collection of the card dashboard item.
            Card card = new Card();            
            card.ActualValue = new Measure("Extended Price", SummaryType.StdDev);
            card.TargetValue = new Measure("Extended Price", SummaryType.StdDevp);            
            cards.Cards.Add(card);

            // Specifies the dimension that provides data for card dashboard item series.
            cards.SeriesDimensions.Add(new Dimension("Sales Person"));
            // Specifies the dimension used to provide sparkline argument values.
            cards.SparklineArgument = new Dimension("OrderDate", DateTimeGroupInterval.MonthYear);

            return cards;
        }
        private void Form1_Load(object sender, EventArgs e) {

            // Creates a dashboard and sets it as a currently opened dashboard in the dashboard viewer.
            dashboardViewer1.Dashboard = new Dashboard();

            // Creates a data source and adds it to the dashboard data source collection.
            DashboardObjectDataSource dataSource = new DashboardObjectDataSource();
            dataSource.DataSource = (new nwindDataSetTableAdapters.SalesPersonTableAdapter()).GetData();
            dashboardViewer1.Dashboard.DataSources.Add(dataSource);

            // Creates a card dashboard item with the specified data source and
            // adds it to the Items collection to display within the dashboard.
            CardDashboardItem cards = CreateCards(dataSource);
            dashboardViewer1.Dashboard.Items.Add(cards);

            // Reloads data in the data sources.
            dashboardViewer1.ReloadData();
        }
    }
}

Form1.vb

Imports System
Imports System.Windows.Forms
Imports DevExpress.DashboardCommon
Imports DevExpress.DataAccess

Namespace Dashboard_CreateCards
    Partial Public Class Form1
        Inherits Form

        Public Sub New()
            InitializeComponent()
        End Sub
        Private Function CreateCards(ByVal dataSource As DashboardObjectDataSource) As CardDashboardItem

            ' Creates a card dashboard item and specifies its data source.
            Dim cards As New CardDashboardItem()
            cards.DataSource = dataSource

            ' Creates a Card object with measures that provide data for calculating the actual and
            ' target values. Then, adds this object to the Cards collection of the card dashboard item.
            Dim card As New Card()
            card.ActualValue = New Measure("Extended Price", SummaryType.StdDev)
            card.TargetValue = New Measure("Extended Price", SummaryType.StdDevp)
            cards.Cards.Add(card)

            ' Specifies the dimension that provides data for card dashboard item series.
            cards.SeriesDimensions.Add(New Dimension("Sales Person"))
            ' Specifies the dimension used to provide sparkline argument values.
            cards.SparklineArgument = New Dimension("OrderDate", DateTimeGroupInterval.MonthYear)

            Return cards
        End Function
        Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load

            ' Creates a dashboard and sets it as a currently opened dashboard in the dashboard viewer.
            dashboardViewer1.Dashboard = New Dashboard()

            ' Creates a data source and adds it to the dashboard data source collection.
            Dim dataSource As New DashboardObjectDataSource()
            dataSource.DataSource = (New nwindDataSetTableAdapters.SalesPersonTableAdapter()).GetData()
            dashboardViewer1.Dashboard.DataSources.Add(dataSource)

            ' Creates a card dashboard item with the specified data source and
            ' adds it to the Items collection to display within the dashboard.
            Dim cards As CardDashboardItem = CreateCards(dataSource)
            dashboardViewer1.Dashboard.Items.Add(cards)

            ' Reloads data in the data sources.
            dashboardViewer1.ReloadData()
        End Sub
    End Class
End Namespace