SqlQueryCollection.AddRange(SqlQuery[]) Method

Appends an array of SQL queries to the SqlQueryCollection.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

C#

public void AddRange(
    SqlQuery[] items
)

VB.NET

Public Sub AddRange(
    items As SqlQuery()
)

Parameters

Name	Type	Description
items	SqlQuery[]	An array of SqlQuery objects to append to the collection.

Remarks

Objects are added to the end of the collection in the same order they have in the array.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AddRange(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#

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

// Add the queries to the data source collection.
ds.Queries.AddRange(new SqlQuery[] { queryCategories, queryProducts });

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

DataSource.Queries.AddRange(new SqlQuery[] { categories, products });
DataSource.Relations.Add(new MasterDetailInfo("Categories", "Products", "CategoryID", "CategoryID"));

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

DataSource.Queries.AddRange(new SqlQuery[] { categories, products });
DataSource.Relations.Add(

VB.NET

reporting-wpf-create-report-in-code/VB/RuntimeReportsApplication/MainWindow.xaml.vb#L68

' Add the queries to the data source collection.
ds.Queries.AddRange(New SqlQuery() {queryCategories, queryProducts})

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

DataSource.Queries.AddRange(New SqlQuery() { categories, products })
DataSource.Relations.Add(New MasterDetailInfo("Categories", "Products", "CategoryID", "CategoryID"))

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

DataSource.Queries.AddRange(New SqlQuery() { categories, products })
DataSource.Relations.Add(New MasterDetailInfo("Categories", "Products", "CategoryID", "CategoryID"))