Back to Devexpress

CustomSqlQuery Class

corelibraries-devexpress-dot-dataaccess-dot-sql-62cd9961.md

latest3.4 KB
Original Source

CustomSqlQuery Class

A custom query.

Namespace : DevExpress.DataAccess.Sql

Assembly : DevExpress.DataAccess.v25.2.dll

NuGet Package : DevExpress.DataAccess

Declaration

csharp
public sealed class CustomSqlQuery :
    SqlQuery
vb
Public NotInheritable Class CustomSqlQuery
    Inherits SqlQuery

The following members return CustomSqlQuery objects:

LibraryRelated API Members
Cross-Platform Class LibraryValidateCustomSqlQueryEventArgs.CustomSqlQuery
DashboardValidateDashboardCustomSqlQueryEventArgs.CustomSqlQuery
ValidateDashboardCustomSqlQueryWebEventArgs.CustomSqlQuery

Remarks

The code sample below demonstrates how to create a CustomSqlQuery that selects all the elements of all the rows of a table.

csharp
using DevExpress.DataAccess;
using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
// ...

private SqlDataSource BindToData() {
    // Create a data source with the required connection parameters.   
    Access97ConnectionParameters connectionParameters =
    new Access97ConnectionParameters("../../Data/nwind.mdb", "", "");
    SqlDataSource ds = new SqlDataSource(connectionParameters);

    // Create an SQL query to access the Products table.
    CustomSqlQuery query = new CustomSqlQuery();
    query.Name = "customQuery1";
    query.Sql = "SELECT * FROM Products";

    ds.Queries.Add(query);
    ds.Fill();
    return ds;
}
vb
Imports DevExpress.DataAccess
Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
' ...

Private Function BindToData() As SqlDataSource
    ' Create a data source with the required connection parameters.   
    Dim connectionParameters As New Access97ConnectionParameters("../../Data/nwind.mdb", "", "")
    Dim ds As New SqlDataSource(connectionParameters)

    ' Create an SQL query to access the Products table.
    Dim query As New CustomSqlQuery()
    query.Name = "customQuery1"
    query.Sql = "SELECT * FROM Products"

    ds.Queries.Add(query)
    ds.Fill()
    Return ds
End Function

Note

Any parameters passed to a CustomSqlQuery should not be multi-value parameters.

Inheritance

Object SqlQuery CustomSqlQuery

See Also

CustomSqlQuery Members

SelectQuery

Bind a Report to an MDB Database (Runtime Sample)

DevExpress.DataAccess.Sql Namespace