SqlDataSourceUIHelper.ManageQueries(SqlDataSource) Method

Invokes the Manage Queries dialog window.

Namespace: DevExpress.DataAccess.UI.Sql

Assembly: DevExpress.DataAccess.v24.2.UI.dll

Declaration

C#

public static bool ManageQueries(
    this SqlDataSource sqlDataSource
)

VB.NET

<ExtensionAttribute>
Public Shared Function ManageQueries(
    sqlDataSource As SqlDataSource
) As Boolean

Parameters

Name	Type	Description
sqlDataSource	SqlDataSource	A SqlDataSource object.

Returns

Type	Description
Boolean	true, if the OK button is clicked in the dialog window; otherwise, false.

Remarks

The following code snippet invokes the Manage Queries dialog window:

C#

using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
using DevExpress.DataAccess.UI.Sql;
// ...
SQLiteConnectionParameters connectionParameters = new SQLiteConnectionParameters("Data/nwind.db", "");
SqlDataSource dataSource = new SqlDataSource(connectionParameters);

SelectQuery query = SelectQueryFluentBuilder
    .AddTable("Products")
    .SelectColumn("ProductName")
    .SelectColumn("UnitPrice")
    .Build("selectQuery");

dataSource.Queries.Add(query);

SqlDataSourceUIHelper.ManageQueries(dataSource);

VB.NET

Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
Imports DevExpress.DataAccess.UI.Sql
' ...
Private connectionParameters As New SQLiteConnectionParameters("Data/nwind.db", "")
Private dataSource As New SqlDataSource(connectionParameters)

Private query As SelectQuery = SelectQueryFluentBuilder.AddTable("Products").SelectColumn("ProductName").SelectColumn("UnitPrice").Build("selectQuery")

dataSource.Queries.Add(query)

SqlDataSourceUIHelper.ManageQueries(dataSource)

Review the following help topic for more information: Query Builder.