Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > Creating the Designer and Viewer Applications > Web Viewer > ASP.NET Web Forms DashboardViewer Control > Providing Data
A newer version of this page is available. .
All docs
V18.2
Dashboard
Getting Started
Basic Concepts and Terminology
Common Features
Creating the Designer and Viewer Applications
WinForms Designer
WinForms Viewer
Web Dashboard
WPF Viewer
Web Viewer
Supported Browsers
Prerequisites
Microsoft Azure Specifics
ASP.NET Web Forms DashboardViewer Control
Adding the ASPxDashboardViewer Control
Loading a Dashboard
Providing Data
Appearance Customization
Client-Side Functionality
ASP.NET MVC DashboardViewer Extension
Manage Exporting Capabilities
Manage Interactivity Capabilities
Manage Dashboard Parameters
Customize Dashboard Colors
Obtaining Underlying and Displayed Data
Access to Underlying Widgets
Creating Dashboards
Visual Studio Integration
End-User Documentation
Localization
Redistribution and Deployment
Video Tutorials
Examples
Member Tables
.NET Framework API Reference
.NET Core API Reference
JavaScript API Reference
Download CHM

Providing Data

  • 3 minutes to read

Important

This documentation applies to v16.2. Starting with v17.1, the ASPxDashboardViewer control is in maintenance mode. In v19.1, the new Web Dashboard Control replaces the old Web Dashboard Viewer. This means that the Web Dashboard Viewer will not be included in our installation packages. See our blog post for more information.

Refer to the following KB articles to learn how to migrate to ASPxDashboard / ASP.NET MVC Dashboard:

This document describes how to bind a dashboard displayed within the ASPxDashboardViewer to data. If you created the dashboard in the WinForms Dashboard Designer or using the Dashboard Designer available at Visual Studio design-time, use one of the following approaches to supply the dashboard displayed within the ASPxDashboardViewer with data.

Used Data Source

Description

SQL Data Source

The dashboard definition contains connection settings such as server names, database names or the entire connection strings. This information is used by the ASPxDashboardViewer to establish a connection to data. You can customize connection settings before connecting to a database using the ASPxDashboardViewer.ConfigureDataConnection/Dashboard.ConfigureDataConnection events. To include WHERE clauses in SQL queries at runtime, handle the ASPxDashboardViewer.CustomFilterExpression/Dashboard.CustomFilterExpression events.

OLAP Data Source

The dashboard definition contains the OLAP connection string. This information is used by the ASPxDashboardViewer to establish a connection to data. You can customize connection settings before connecting to an OLAP cube using the ASPxDashboardViewer.ConfigureDataConnection/Dashboard.ConfigureDataConnection events.

Excel Data Source

The dashboard definition contains the path to the Excel workbook/CSV file. This information is used by the ASPxDashboardViewer to establish a connection to data. You can customize connection settings before connecting to an Excel Data Source using the ASPxDashboardViewer.ConfigureDataConnection/Dashboard.ConfigureDataConnection events.

Entity Framework Data Source

In this case, the dashboard definition can contain the following settings.

  • The dashboard definition contains the context name and the connection string name. In this case, the ASPxDashboardViewer‘s project should include the corresponding context class and the connection string in the application configuration file.
  • The dashboard definition contains the context name, the path to the external assembly and the custom connection string. In this case, the ASPxDashboardViewer uses these settings to establish a connection to data.

Object Data Source

The dashboard definition contains the name of the class used to provide data and optionally, the data member. You need to supply the dashboard with actual data at runtime using the ASPxDashboardViewer.DataLoading/Dashboard.DataLoading event.

Extract Data Source

The dashboard definition contains the path to the data extract. This information is used by the ASPxDashboardViewer to establish a connection to data. You can customize connection settings before connecting to an Extract Data Source using the ASPxDashboardViewer.ConfigureDataConnection/Dashboard.ConfigureDataConnection events.

Use the ASPxClientDashboardViewer.ReloadData method to reload data in all dashboard data sources.

See Also