ConnectionHelperExecuteQuery Method (String, QueryDataParameters, String, String, Int32, String, Int32, Int32, Int32) |
Executes query and returns result as a dataset.
Namespace: CMS.DataEngineAssembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0
Syntaxpublic static DataSet ExecuteQuery(
string queryName,
QueryDataParameters parameters,
string where,
string orderBy,
int topN,
string columns,
int offset,
int maxRecords,
ref int totalRecords
)
Parameters
- queryName
- Type: SystemString
Name of the query in format application.class.queryname - parameters
- Type: CMS.DataEngineQueryDataParameters
Query parameters - where
- Type: SystemString
WHERE expression - orderBy
- Type: SystemString
Sort expression - topN
- Type: SystemInt32
Top N expression - columns
- Type: SystemString
Columns expression - offset
- Type: SystemInt32
Index of first record to get - maxRecords
- Type: SystemInt32
Maximum number of records to get. If maxRecords is zero or less, all records are returned (no paging is used) - totalRecords
- Type: SystemInt32
Returns total records
Return Value
Type:
DataSet
See Also