CustomSqlQuery.Sql Property

Specifies the custom query string.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

[LocalizableCategory(DataAccessStringId.QueryPropertyGridCustomSqlCategoryName)]
public string Sql { get; set; }

VB.NET

<LocalizableCategory(DataAccessStringId.QueryPropertyGridCustomSqlCategoryName)>
Public Property Sql As String

Property Value

Type	Description
String	A String value, specifying the query.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Sql property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

reporting-wpf-create-report-in-code/CS/RuntimeReportsApplication/MainWindow.xaml.cs#L51

queryCategories.Name = "queryCategories";
queryCategories.Sql = "SELECT * FROM Categories";

winforms-grid-create-configure-sql-data-source/CS/dxSample/Form1.cs#L45

query.Name = "customQuery1";
query.Sql = "SELECT * FROM Products";
ds.Queries.Add(query);

reporting-web-forms-report-designer-add-data-sources/CS/WebApplication1/Default.aspx.cs#L76

query.Name = "customQuery1";
query.Sql = "SELECT * FROM Products";

how-to-create-data-access-library-data-sources-at-runtime-t424210/CS/SqlDataSourceSnippets/Code.cs#L62

query.Name = "CustomQuery";
query.Sql = "Select top 10 * from Products";

mvc-dashboard-customize-before-displaying-browser/CS/MVCxDashboard/App_Start/DashboardConfig.cs#L34

if (customNwindQuery != null) {
    customNwindQuery.Sql += " AND (Invoices.OrderDate >= #2015-01-01 00:00:00#)";
}

VB.NET

winforms-grid-create-configure-sql-data-source/VB/dxSample/Form1.vb#L53

query.Name = "customQuery1"
query.Sql = "SELECT * FROM Products"
ds.Queries.Add(query)

reporting-web-forms-report-designer-add-data-sources/VB/WebApplication1/Default.aspx.vb#L68

query.Name = "customQuery1"
query.Sql = "SELECT * FROM Products"

how-to-create-data-access-library-data-sources-at-runtime-t424210/VB/SqlDataSourceSnippets/Code.vb#L42

query.Name = "CustomQuery"
query.Sql = "Select top 10 * from Products"

reporting-winforms-group-at-runtime/VB/DataGrouping/Form1.vb#L26

query.Name = "customQuery"
query.Sql = "SELECT * FROM CategoryProducts"
ds.Queries.Add(query)

winforms-dashboard-pass-dashboard-parameters-to-custom-sql-query-in-code/VB/Dashboard_ParametersAndCustomSQL/Form1.vb#L26

salesPersonQuery.Parameters.Add(New QueryParameter("endDate", GetType(Expression), New Expression("[Parameters.yearParameter] + '/12/31'")))
salesPersonQuery.Sql = "select * from SalesPerson where OrderDate between @startDate and @endDate"