ConnectionHelper.ExecuteQuery Method (String, QueryDataParameters, String, String, Int32, String, Int32, Int32, Int32)

Executes query and returns result as a dataset.

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

Parameters

queryName

Type: System.String
Name of the query in format application.class.queryname

parameters

Type: CMS.DataEngine.QueryDataParameters
Query parameters

where

Type: System.String
WHERE expression

orderBy

Type: System.String
Sort expression

topN

Type: System.Int32
Top N expression

columns

Type: System.String
Columns expression

offset

Type: System.Int32
Index of first record to get

maxRecords

Type: System.Int32
Maximum number of records to get. If maxRecords is zero or less, all records are returned (no paging is used)

totalRecords

Type: System.Int32
Returns total records

Return Value

Type: DataSet