All docs
V20.2
20.2
20.1
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

SqlDataSource.FillAsync(String[], CancellationToken) Method

Populates the SqlDataSource in an asynchronous manner and uses the cancellationToken parameter to send the cancellation signal. You can specify which queries to execute in order to populate the data source.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v20.2.dll

Declaration

public Task FillAsync(
    string[] queriesToFill,
    CancellationToken cancellationToken
)
Public Function FillAsync(
    queriesToFill As String(),
    cancellationToken As CancellationToken
) As Task

Parameters

Name Type Description
queriesToFill String[]

Queries to execute in order to populate the data source.

cancellationToken CancellationToken

A cancellation token that the task observes.

Returns

Type Description
Task

A task that populates the data source.

Remarks

Use this method to populate an SQL data source in an individual task asynchronously. Unlike the Fill() method call, FillAsync does not lock other actions performed concurrently. For instance, the user interface remains operational while the data source is populated.

Call the FillAsync method with the await operator.

The queriesToFill array specifies the names of the queries to execute in order to populate the data source.

The cancellationToken parameter provides a way to send the cancellation signal to the task. The task monitors the token and stops when it receives the signal. Create a CancellationTokenSource class instance and pass its Token property to the FillAsync method call. Call the CancellationTokenSource.Cancel method to stop the task.

All queries listed in the queriesToFill method are validated one by one. If any validation errors occur, an AggregateException is thrown with these errors. Use the exception's InnerExceptions property to access a collection of QueryExecutionException objects (use their InnerException property to access an actual ValidationException).

If the validation succeeds, all listed queries are executed one by one. If any errors occur, an AggregateException is thrown with these errors. Use the exception's InnerExceptions property to access a collection of QueryExecutionException objects (use their InnerException property to access an actual DevExpress.DataAccess.Native.Sql.SqlExecutionException).

Example

The code sample below creates an SqlDataSource, binds the data source query's OrderIDs parameter to the OrderIDsParameter report parameter, and populates the data source in an asynchronous manner. A CancellationTokenSource class instance is used to allow users to interrupt the data source fill process if it takes too long.

using System.Threading;
using System.Threading.Tasks;
using DevExpress.DataAccess;
using DevExpress.DataAccess.Sql;
using DevExpress.DataAccess.ConnectionParameters;
// ...
// Use the cancellationTokenSource to allow users to stop populating the data source.
CancellationTokenSource cancellationTokenSource = new CancellationTokenSource();
// ...
// The cancelButton_Click event handler uses the cancellationTokenSource to stop populating the data source.
private void cancelButton_Click(object sender, EventArgs e) {
    cancellationTokenSource.Cancel();
}
// ...
// Create and configure an SQL data source.
Access97ConnectionParameters connectionParameters = new Access97ConnectionParameters(".\\Data\\nwind.mdb", "", "");
DevExpress.DataAccess.Sql.SqlDataSource dataSource = new DevExpress.DataAccess.Sql.SqlDataSource(connectionParameters);
// The "queryInvoices" query uses the "OrderIDs" query parameter that is bound to the "OrderIDsParameter" report parameter.
CustomSqlQuery queryInvoices = new CustomSqlQuery();
queryInvoices.Name = "queryInvoices";
queryInvoices.Sql = "SELECT OrderID, OrderDate, ShipName, sum(ExtendedPrice) as Total FROM Invoices GROUP BY OrderID,OrderDate,ShipName";
dataSource.Queries.Add(queryInvoices);
report.DataSource = dataSource;
report.DataMember = "queryInvoices";
// Populate the data source.
await dataSource.FillAsync(new string[] { "queryInvoices" }, cancellationTokenSource.Token);
See Also