DataSourceManager.GetDataSources<TDataSource>(XtraReport, Boolean) Method

Returns all report data sources of the specified type.

Namespace: DevExpress.XtraReports

Assembly: DevExpress.XtraReports.v25.2.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

public static IEnumerable<TDataSource> GetDataSources<TDataSource>(
    XtraReport report,
    bool includeSubReports = false
)
    where TDataSource : class

VB.NET

Public Shared Function GetDataSources(Of TDataSource As Class)(
    report As XtraReport,
    includeSubReports As Boolean = False
) As IEnumerable(Of TDataSource)

Parameters

Name	Type	Description
report	XtraReport	A report instance.

Optional Parameters

Name	Type	Default	Description
includeSubReports	Boolean	False	true to include data sources from subreports; otherwise, false.

Type Parameters

Name	Description
TDataSource	The data source type.

Returns

Type	Description
IEnumerable<TDataSource>	A collection of report data sources.

Example

The following code template shows how to use the GetDataSources method to retrieve all data sources of the SqlDataSource type and update their query parameters.

C#

using DevExpress.DataAccess.Sql;
using DevExpress.XtraReports;
//...

var report = new XtraReport1();

var sqlDataSources = DataSourceManager.GetDataSources<SqlDataSource>(
    report: report,
    includeSubReports: true
);

foreach (var sqlDataSource in sqlDataSources) {
    foreach (var query in sqlDataSource.Queries) {
        query.Parameters["paramName"].Value = 32;
    }
}

VB.NET

Imports DevExpress.DataAccess.Sql
Imports DevExpress.XtraReports
'...

Private report = New XtraReport1()

Private sqlDataSources = DataSourceManager.GetDataSources(Of SqlDataSource)(report:= report, includeSubReports:= True)

For Each sqlDataSource In sqlDataSources
    For Each query In sqlDataSource.Queries
        query.Parameters("paramName").Value = 32
    Next query
Next sqlDataSource

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the GetDataSources<TDataSource>(XtraReport, Boolean) 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-asp-net-core-inject-data-from-efcore-dbcontext-into-report-using-object-data-source/CS/xrefcoredemo/Services/ObjectDataSourceInjector.cs#L24

public void Process(XtraReport report) {
    foreach (var ods in DataSourceManager.GetDataSources<ObjectDataSource>(report, includeSubReports: true)) {
        if (ods.DataSource is Type dataSourceType) {