ASPxDashboard.EnableCustomSql Property

Enables a user to specify a custom SQL string in the Data Source wizard.

Assembly : DevExpress.Dashboard.v25.2.Web.WebForms.dll

NuGet Package : DevExpress.Web.Dashboard

Declaration

C#
VB.NET

csharp

[DefaultValue(false)]
public bool EnableCustomSql { get; set; }

<DefaultValue(False)>
Public Property EnableCustomSql As Boolean

Property Value

Type	Default	Description
Boolean	false

true , to allow a user to specify a custom SQL string in the Data Source wizard; otherwise, false.

Remarks

Note that the ASPxDashboard.ValidateDashboardCustomSqlQuery event is raised each time an end-user creates a new SQL data source/custom SQL query in the Data Source wizard or edits the existing data source/SQL Query.

Executing custom SQL queries is forbidden by default. Use the AllowExecutingCustomSql property to allow the Web Dashboard to execute SQL queries on the server side.

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 Custom SQL Queries for more information.