ValidateDashboardCustomSqlQueryWebEventArgs.ExceptionMessage Property
Gets or sets the exception message returned after custom SQL query validation.
Namespace: DevExpress.DashboardWeb
Assembly: DevExpress.Dashboard.v24.1.Web.dll
NuGet Package: DevExpress.Web.Dashboard.Common
Declaration
Property Value
Type | Description |
---|---|
String | A String value that specifies the exception message returned after custom SQL query validation. |
Remarks
By default, a custom query used to obtain data from the SQL database should contain only SELECT statements. If the custom query contains not only SELECT statements or the query is specified incorrectly, the ValidateDashboardCustomSqlQueryWebEventArgs.Valid property is set to false. The ExceptionMessage property returns the corresponding exception message.
If necessary, you can check the validity of the custom SQL query manually and override the value of the ValidateDashboardCustomSqlQueryWebEventArgs.Valid flag and corresponding ExceptionMessage message.