SqlQuery Class

A formalized description of a database query used to select data from SqlDataSource.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v20.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.WindowsDesktop.DataAccess

Declaration

C#
VB.NET

public abstract class SqlQuery :
    IQuery

Public MustInherit Class SqlQuery
    Implements IQuery

Library	Related API Members
Cross-Platform Class Library	ISqlDataSourceModel.Query
QueryBuilderRunnerBase.Create()
QueryBuilderRunnerBase.Edit(SqlQuery)
SqlDataSourceModel.Query
SqlQueryCollection.Item[Int32]
SqlQueryCollection.Item[String]
Reporting	DataSetToSqlDataSourceConverter.CreateSqlQuery(String, IDbCommand)

Remarks

The result of any query is always a two-dimensional table containing the data records.

The SqlDataSource class exposes the SqlDataSource.Queries property that provides access to a collection of SqlQuery objects.

The following code snippets (auto-collected from DevExpress Examples) contain references to the SqlQuery class.

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#
VB.NET

Reporting_how-to-use-the-web-document-viewer-in-javascript-with-reactjs-t561300/CS/ServerSide/XtraReport2.cs#L117

selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1});

Reporting_how-to-use-the-web-report-designer-in-javascript-with-reactjs-t561295/CS/ServerSide/XtraReport1.cs#L123

selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1});

Reporting_how-to-use-the-web-document-viewer-in-javascript-with-reactjs-t561300/VB/ServerSide/XtraReport2.vb#L119

selectQuery1.Tables.Add(table1)
Me.sqlDataSource1.Queries.AddRange(New DevExpress.DataAccess.Sql.SqlQuery() { selectQuery1})
Me.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable")

Reporting_how-to-use-the-web-report-designer-in-javascript-with-reactjs-t561295/VB/ServerSide/XtraReport1.vb#L125

selectQuery1.Tables.Add(table1)
Me.sqlDataSource1.Queries.AddRange(New DevExpress.DataAccess.Sql.SqlQuery() { selectQuery1})
Me.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable")