SqlQueryCollection.Add(SqlQuery) Method

Adds the specified query to the collection.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

C#

public void Add(
    SqlQuery item
)

VB.NET

Public Sub Add(
    item As SqlQuery
)

Parameters

Name	Type	Description
item	SqlQuery	A SqlQuery object.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Add(SqlQuery) method.

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#

data-access-library-create-data-sources-at-runtime/CS/SqlDataSourceSnippets/Code.cs#L34

                    .Build("Categories");
DataSource.Queries.Add(query);

DashboardUserBasedMVC/CS/MVCDashboard/Code/CustomDataSourceStorage.cs#L24

    .Build("Categories");
sqlDataSource1.Queries.Add(query1);
SelectQuery query2 = SelectQueryFluentBuilder

reporting-winforms-sql-data-source-runtime/CS/RuntimeSqlDataSourceReportSample/Form1.cs#L46

DataSource.Queries.Add(QueryHelper.CreateSelectQuery());
DataSource.Queries.Add(QueryHelper.CreateCustomSqlQuery());

reporting-wpf-create-drill-down-report-document-preview-control/CS/dxWPFApp/MainWindow.xaml.cs#L129

SqlDataSource ds = new SqlDataSource(new Access2007ConnectionParameters(@"..\..\App_Data\nwind.mdb", ""));
ds.Queries.Add(new CustomSqlQuery("Categories", "select * from Categories"));
ds.RebuildResultSchema();

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

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

VB.NET

data-access-library-create-data-sources-at-runtime/VB/SqlDataSourceSnippets/Code.vb#L22

Dim query As SelectQuery = SelectQueryFluentBuilder.AddTable("Categories").SelectColumn("CategoryName").GroupBy("CategoryName").Join("Products", "CategoryID").SelectColumn("ProductName", AggregationType.Count, "ProductCount").SortBy("ProductName", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending).GroupFilter("[ProductCount] > 7").Build("Categories")
DataSource.Queries.Add(query)

reporting-winforms-sql-data-source-runtime/VB/RuntimeSqlDataSourceReportSample/Form1.vb#L42

DataSource.Queries.Add(QueryHelper.CreateSelectQuery())
DataSource.Queries.Add(QueryHelper.CreateCustomSqlQuery())

reporting-wpf-create-drill-down-report-document-preview-control/VB/dxWPFApp/MainWindow.xaml.vb#L132

Dim ds As New SqlDataSource(New Access2007ConnectionParameters("..\..\App_Data\nwind.mdb", ""))
ds.Queries.Add(New CustomSqlQuery("Categories", "select * from Categories"))
ds.RebuildResultSchema()

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

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

reporting-mvc-db-storage/VB/DXWebApplication_ReportDesigner/Controllers/DesignerController.vb#L46

ds.Name = "NWind"
ds.Queries.Add(New CustomSqlQuery("Categories", "SELECT * FROM [Categories]"))
ds.RebuildResultSchema()