GeneralConnection ExecuteQuery Method (String, QueryDataParameters, QueryMacros, Int32, Int32, Int32 )Kentico 8.1 API Reference
Executes query and returns result as a dataset.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 8.0.0.0 (8.1.5347.20411)

Parameters

queryName
Type: OnlineSystem String
Name of the query in format application.class.queryname
parameters
Type: CMS.DataEngine QueryDataParameters
Query parameters
macros
Type: CMS.DataEngine QueryMacros
Query expressions
offset
Type: OnlineSystem Int32
Index of first record to get
maxRecords
Type: OnlineSystem Int32
Maximum number of records to get. If maxRecords is zero or less, all records are returned (no paging is used)
totalRecords
Type: OnlineSystem Int32 
Returns total records

Return Value

Type: OnlineDataSet
See Also