SqlDataSource.Fill(String[]) Method

Validates and executes the specified queries.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

C#

public void Fill(
    params string[] queriesToFill
)

VB.NET

Public Sub Fill(
    ParamArray queriesToFill As String()
)

Parameters

Name	Type	Description
queriesToFill	String[]	An array of String values, specifying the queries to fill.

Remarks

If errors occur during data connection, a DatabaseConnectionException is thrown.

All queries are validated one by one. When validation errors occur, they are collected and returned by throwing a AggregateException. Use its InnerExceptions property to access a collection of QueryExecutionException objects (use their InnerException property to access an actual ValidationException).

If the validation succeeds, all queries are executed one by one. If any errors occur during the execution of each query, these errors are collected and returned by throwing a AggregateException. Use its InnerExceptions property to access a collection of QueryExecutionException objects (use their InnerException property to access an actual DevExpress.DataAccess.Native.Sql.SqlExecutionException).

Related GitHub Examples

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

web-forms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/CS/ASPxDashboard/Default.aspx.cs#L31

sqlDS.ConnectionName = dataSource.ConnectionName;
sqlDS.Fill(query.Name);

winforms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/CS/WinFormsDashboard/ViewerForm.cs#L53

sqlDS.ConnectionName = "Connection";
sqlDS.Fill(query.Name);

VB.NET

web-forms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/VB/ASPxDashboard/Default.aspx.vb#L27

sqlDS.ConnectionName = dataSource.ConnectionName
sqlDS.Fill(query.Name)

winforms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/VB/WinFormsDashboard/ViewerForm.vb#L55

sqlDS.ConnectionName = "Connection"
sqlDS.Fill(query.Name)