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

Declaration

public override void Fill(
    IEnumerable<IParameter> sourceParameters
)
Public Overrides Sub Fill(
    sourceParameters As IEnumerable(Of IParameter)
)

Parameters

Name Type Description
sourceParameters IEnumerable<IParameter>

A collection of query parameters.

Examples

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.

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") });
See Also