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 > Use the Query Editor
All docs
V24.2
Business Intelligence Dashboard
Get Started
.NET Support
What's New
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

Use the Query Editor

The Query Editor dialog allows you to create new SQL queries or edit the existing queries created using the Data Source wizard. Optionally, you can add query parameters.

The Query Editor can contain two pages depending on the current query.

  1. The first page allows you to specify the query or select the stored procedure.

    QueryEditorDialog_Page1

    You can choose the following options to create/modify a query.

    • Select the Query option and run the Query Builder by clicking the Run Query Builder… button. The Query Builder allows you to choose the required tables/columns visually and displays the resulting SQL query within the SQL String editor.
    • Select the Query option and specify the SQL query manually in the SQL String editor.

      Important

      Note that the Query Editor does not allow you to use custom SQL queries by default. To enable this capability, set the DashboardDesigner.DataSourceWizard.SqlWizardSettings.EnableCustomSql property to true.

    • If available, select the Stored Procedure option to select one of the stored procedures from the database.

  2. The second page of the Query Editor allows you to add or modify query parameters.

    QueryEditorDialog_Page2