Skip to main content
All docs
V25.1
  • DashboardExporter.ValidateCustomSqlQuery Event

    Allows you to validate a custom SQL query of the DashboardSqlDataSource.

    Namespace: DevExpress.DashboardCommon

    Assembly: DevExpress.Dashboard.v25.1.Core.dll

    NuGet Package: DevExpress.Dashboard.Core

    Declaration

    public event ValidateDashboardCustomSqlQueryEventHandler ValidateCustomSqlQuery

    Event Data

    The ValidateCustomSqlQuery event's data class is ValidateDashboardCustomSqlQueryEventArgs. The following properties provide information specific to this event:

    Property Description
    ConnectionName Gets the name of the connection to the data source containing a custom SQL query.
    ConnectionParameters Gets parameters used to establish a connection to the data source containing a custom SQL query.
    CustomSqlQuery Gets the custom SQL query that should be checked.
    DataSourceComponentName Gets or sets the component name of the data source for which the event was raised.
    DataSourceName Gets or sets the name of the data source for which the event was raised.
    ExceptionMessage Gets or sets the exception message returned after custom SQL query validation.
    Valid Gets or sets whether the current custom SQL query is valid.

    Remarks

    This event occurs before a CustomSqlQuery is executed. Custom Queries are stored in the Queries collection of the DashboardSqlDataSource.

    The event fires for each custom SQL query in the following cases:

    • The control loads a dashboard that gets data from a custom SQL query.
    • The control’s ReloadData method forces the DashboardSqlDataSource to update its data.

    Note

    For security reasons, only SELECT queries are allowed and valid. If the custom query contains statements other than SELECT, or the query is specified incorrectly, the e.Valid property is set to false. The e.ExceptionMessage property contains the text specified by the DataAccessStringId.CustomSqlQueryValidationException value.

    If necessary, you can disable query validation and allow users to include other statements in addition to SELECT statements in SQL queries. To accomplish this, follow the steps below:

    See Also