Click or drag to resize
ConnectionHelperExecuteQuery Method (String, QueryDataParameters, String, String, Int32, String)
Executes query and returns result as a dataset.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0
Syntax
C#
public static DataSet ExecuteQuery(
	string queryName,
	QueryDataParameters parameters,
	string where = null,
	string orderBy = null,
	int topN = 0,
	string columns = null
)

Parameters

queryName
Type: SystemString
Name of the query in format application.class.queryname
parameters
Type: CMS.DataEngineQueryDataParameters
Query parameters
where (Optional)
Type: SystemString
WHERE expression
orderBy (Optional)
Type: SystemString
Sort expression
topN (Optional)
Type: SystemInt32
Top N expression
columns (Optional)
Type: SystemString
Columns expression

Return Value

Type: DataSet
See Also