XRDesignMdiController.ValidateCustomSql Event

Occurs when a custom SQL query is validated.

Namespace : DevExpress.XtraReports.UserDesigner

Assembly : DevExpress.XtraReports.v25.2.Extensions.dll

NuGet Package : DevExpress.Win.Reporting

Declaration

C#
VB.NET

csharp

public event EventHandler<ValidateSqlEventArgs> ValidateCustomSql

Public Event ValidateCustomSql As EventHandler(Of ValidateSqlEventArgs)

Event Data

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

Property	Description
ConnectionParameters	Provides access to settings used to establish the current data connection.
Message	Specifies the error message to display if query validation fails.
Sql	Contains the SQL query to validate.
Valid	Specifies whether the query is valid.

Remarks

This event is raised when a user enters a custom SQL query in the Report Designer’s Query Builder UI. Use this event when you want to control/validate custom SQL queries entered by the user. Define your custom query validation logic in the event handler as follows:

Select the Report Designer’s XRDesignMdiController in the component tray:
Handle the XRDesignMdiController.ValidateCustomSql event:
In the event handler, define your custom query validation logic:

To validate custom SQL for all queries created in an End-User Report Designer for WinForms, handle the SqlDataSource.ValidateCustomSqlQueryGlobal event.