Click or drag to resize

DataAccessExecuteQuery Method (String, String, Int32, Int32, Boolean)

Returns a dataset loaded with the results of the specified select SQL query

Namespace:  WorkflowGen.My.Data
Assembly:  WorkflowGen.My (in WorkflowGen.My.dll) Version: 9.0.3.0 (9.0.3.20240719)
Syntax
public DataSet ExecuteQuery(
	string sqlQuery,
	string tableIdentifier,
	int pageNumber,
	int pageSize,
	bool countTotalRows
)

Parameters

sqlQuery
Type: SystemString
A select SQL query
tableIdentifier
Type: SystemString
A table name identifier
pageNumber
Type: SystemInt32
The record number to start with
pageSize
Type: SystemInt32
The number of records per page
countTotalRows
Type: SystemBoolean
A boolean which determines whether or not to count the total number of rows regardless the paging settings

Return Value

Type: DataSet
The loaded dataset
See Also