Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > WinForms Dashboard > WinForms Designer > Create Dashboards in the WinForms Designer > Provide Data > SQL Data Source > Stored Procedures
All docs
V23.2
Business Intelligence Dashboard
Get Started
.NET Support
Basic Concepts and Terminology
Common Features
WinForms Dashboard
General Information
WinForms Designer
Add the Dashboard Designer Control
Register Default Data Connections
Create Dashboards in the WinForms Designer
Create a Dashboard
Provide Data
SQL Data Source
Connect to SQL Databases
Edit Connection Parameters
Use the Query Builder
Use the Query Editor
Manage SQL Queries
Filter Queries
Use Query Parameters
Custom SQL Queries
Stored Procedures
Custom Database Schema
Preview Data
Manage Timeout Limit
Save Connection Parameters
OLAP Data Source
Excel Data Source
Entity Framework Data Source
Object Data Source
JSON Data Source
XPO Data Source
Extract Data Source
Federated Data Source
MongoDB
Calculated Fields
Data Processing Modes
Add Dashboard Items
Bind Dashboard Items to Data
Dashboard Item Settings
Data Shaping
Interactivity
Appearance Customization
Data Analysis
Convert Dashboard Items
Dashboard Layout
Dashboard Items Layout
Undo and Redo Operations
Automatic and Manual Updates
Save a Dashboard
Printing and Exporting
UI Elements and Customization
Manage Dashboard State
Manage Data Inspector
WinForms Viewer
Web Dashboard
WPF Dashboard Viewer
Visual Studio Integration
Redistribution and Deployment
Video Tutorials
Migration Guides
Examples
End-User Documentation
.NET Framework API Reference
.NET API Reference
HTML JS Control API Reference
ASP.NET Client API Reference
Download CHM

Stored Procedures

If you use a stored procedure to supply the dashboard with data, you should specify the stored procedure parameters. In the Query Editor dialog, select the required stored procedure and click Next.

QueryEditorDialog_StoredProcedure

On the next page, you can specify the parameter settings.

QueryEditorDialog_StoredProcedureParameters

  • Name - Displays the parameter name.
  • Type - Displays the parameter type.
  • Expression - Specifies whether the expression is used to specify a parameter value.
  • Value - Specifies a parameter value. If the Expression check box is checked, you can invoke the Expression Editor dialog to specify the required expression or select an existing dashboard parameter to use it as a stored procedure parameter.

Click the Preview… button to preview the query result. Then, click Finish to complete query modification.

Note

If you bind a DashboardSqlDataSource component to a stored procedure that returns multiple data tables, the Dashboard Control uses only the first table.

Supported Data Providers

The following data providers allow you to use stored procedures to supply the dashboard with data.