FederationDataSourceBase.Fill(IEnumerable<IParameter>) Method

Populates the data source with data by running the queries with the specified parameters.

Namespace: DevExpress.DataAccess.DataFederation

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

C#

public override void Fill(
    IEnumerable<IParameter> sourceParameters
)

VB.NET

Public Overrides Sub Fill(
    sourceParameters As IEnumerable(Of IParameter)
)

Parameters

Name	Type	Description
sourceParameters	IEnumerable<IParameter>	A collection of query parameters.

Example

This code snippet demonstrates how to create a federated data source that uses a filter with a parameter.

Note

The complete sample project How to Create a Federated Data Source at Runtime is available in the DevExpress Examples repository.

C#

using DevExpress.DataAccess.DataFederation;
// ...
    FederationDataSource federation = new FederationDataSource();

    Source source = new Source("excelSource", CreateExcelDataSource("SalesPerson.xlsx", "Data"));

    var sourceNode = new SourceNode(source, "Orders");

    var query = new SelectNode(sourceNode)
    {
        Alias = "excel",
        Expressions = {
                new SelectColumnExpression(sourceNode, "OrderID"),
                new SelectColumnExpression(sourceNode, "OrderDate"),
                new SelectColumnExpression(sourceNode, "Sales Person"),
                new SelectColumnExpression(sourceNode, "ProductName"),
                new SelectColumnExpression(sourceNode, "Extended Price")
            },
        FilterString = "[Orders.CategoryName] = ?cat",
    };
    federation.Queries.Add(query);
    federation.Fill(new[] { 
        new DevExpress.DataAccess.Sql.QueryParameter("cat", typeof(string), "Seafood") });

VB.NET

Imports DevExpress.DataAccess.DataFederation
' ... 
    Dim federation As New FederationDataSource()

    Dim source As New Source("excelSource", CreateExcelDataSource("SalesPerson.xlsx", "Data"))

    Dim sourceNode = New SourceNode(source, "Orders")

    Dim query = New SelectNode(sourceNode)
    query.Alias = "excel"
    query.Expressions.Add(New SelectColumnExpression(sourceNode, "OrderID"))
    query.Expressions.Add(New SelectColumnExpression(sourceNode, "OrderDate"))
    query.Expressions.Add(New SelectColumnExpression(sourceNode, "Sales Person"))
    query.Expressions.Add(New SelectColumnExpression(sourceNode, "ProductName"))
    query.Expressions.Add(New SelectColumnExpression(sourceNode, "Extended Price"))
    query.FilterString = "[Orders.CategoryName] = ?cat"
    federation.Queries.Add(query)
    federation.Fill( { 
        New DevExpress.DataAccess.Sql.QueryParameter("cat", GetType(String), "Seafood") })

Related GitHub Examples

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

winforms-dashboard-data-federation/CS/DataFederationExample/Form1.cs#L103

federationDS.Fill(new DevExpress.Data.IParameter[0]);
return federationDS;

create-a-federated-data-source-at-runtime/CS/FederationDataSourceExample/FederationDataSourceHelper.cs#L37

federation.Queries.Add(query);
federation.Fill(new[] { new DevExpress.DataAccess.Sql.QueryParameter("cat", typeof(string), "Seafood") });
var result = ((IListSource)federation).GetList() as IResultSet;

VB.NET

winforms-dashboard-data-federation/VB/DataFederationExample/Form1.vb#L99

federationDS.Fill(New DevExpress.Data.IParameter(){})
Return federationDS

create-a-federated-data-source-at-runtime/VB/FederationDataSourceExample/FederationDataSourceHelper.vb#L28

federation.Queries.Add(query)
federation.Fill( { New DevExpress.DataAccess.Sql.QueryParameter("cat", GetType(String), "Seafood") })
Dim result = TryCast(DirectCast(federation, IListSource).GetList(), IResultSet)