Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > WinForms Dashboard > WinForms Designer > UI Elements and Customization > Dialogs and Wizards > Query Builder
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
UI Elements and Customization
UI Elements
Dialogs and Wizards
Data Source Wizard
Query Builder
Print Preview Form
Access to Underlying Controls
Create Custom Properties
Create a Custom Item
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

Query Builder

In the Query Builder dialog, you can add data tables and views to the data source, and select which columns to include. This topic describes options that allow you to customize the UI of the Query Builder.

DataBinding_QueryDesignerPanes

The following customization options are available.

  • You can customize a database schema to display only certain database entities in the Tables/Diagram panes. For more information on how to implement a custom database schema provider, refer to the following article: Custom Database Schema Provider in WinForms.
  • The SqlWizardSettings.QueryBuilderDiagramView property allows you to specify whether the Query Builder should use a table-like or a diagram-based interface for selecting fields.
  • The SqlWizardSettings.QueryBuilderLight property specifies whether the Query Builder allows end-users to specify custom SQL queries (SQL pane), aliases (Grid pane | Aliases column) and expressions.

  • By default, the Query Builder does not allow end-users to change SQL queries in the SQL pane. To enable this capability, set the SqlWizardSettings.EnableCustomSql property to true.

    Warning

    The use of custom SQL queries can lead to inadvertent or unauthorized modifications to your data/database structure. Ensure that you follow best practices and implement the appropriate user read/write privileges at database level.

See Also