corelibraries-devexpress-dot-dataaccess-dot-sql-62cd9961.md
A custom query.
Namespace : DevExpress.DataAccess.Sql
Assembly : DevExpress.DataAccess.v25.2.dll
NuGet Package : DevExpress.DataAccess
public sealed class CustomSqlQuery :
SqlQuery
Public NotInheritable Class CustomSqlQuery
Inherits SqlQuery
The following members return CustomSqlQuery objects:
| Library | Related API Members |
|---|---|
| Cross-Platform Class Library | ValidateCustomSqlQueryEventArgs.CustomSqlQuery |
| Dashboard | ValidateDashboardCustomSqlQueryEventArgs.CustomSqlQuery |
| ValidateDashboardCustomSqlQueryWebEventArgs.CustomSqlQuery |
The code sample below demonstrates how to create a CustomSqlQuery that selects all the elements of all the rows of a table.
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;
}
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.
Object SqlQuery CustomSqlQuery
See Also