DataSourceManager.GetDataSources(XtraReport, Boolean) Method

Returns all report data sources.

Namespace: DevExpress.XtraReports

Assembly: DevExpress.XtraReports.v23.1.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

public static IEnumerable<object> GetDataSources(
    XtraReport report,
    bool includeSubReports = false
)

VB.NET

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

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.

Returns

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

Example

The following code sample shows how to get all report data sources (except for subreport data sources), iterate through these data sources, and update settings (the ConnectionName property) of each data source whose type is SqlDataSource.

C#

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

var report = new XtraReport1();

var dataSources = DataSourceManager.GetDataSources(report, includeSubReports: false);

foreach (var dataSource in dataSources) {
    if (dataSource is SqlDataSource) {
        (dataSource as SqlDataSource).ConnectionName = "nwind";
    }
}

VB.NET

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

Private report = New XtraReport1()

Private dataSources = DataSourceManager.GetDataSources(report, includeSubReports:= False)

For Each dataSource In dataSources
    If TypeOf dataSource Is SqlDataSource Then
        TryCast(dataSource, SqlDataSource).ConnectionName = "nwind"
    End If
Next dataSource