ContextQMD
Back to Devexpress

Stored Procedures

dashboard-113946-winforms-dashboard-winforms-designer-create-dashboards-in-the-winforms-designer-providing-data-sql-data-source-stored-procedures.md

latest3.9 KB
Original Source

Stored Procedures

  • Nov 23, 2022

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.

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

  • 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.