Skip to main content

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.v22.2.dll

NuGet Package: DevExpress.DataAccess


public override void Fill(
    IEnumerable<IParameter> sourceParameters


Name Type Description
sourceParameters IEnumerable<IParameter>

A collection of query parameters.


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


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

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.Fill(new[] { 
        new DevExpress.DataAccess.Sql.QueryParameter("cat", typeof(string), "Seafood") });

The following code snippets (auto-collected from DevExpress Examples) contain references to the Fill(IEnumerable<IParameter>) method.


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.

See Also