DataAccessExecuteQuery Method (String, Hashtable, String, Int32, Int32) |
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: 8.0.5.0 (8.0.5.20210818)
Syntax public DataSet ExecuteQuery(
string sqlQuery,
Hashtable parameters,
string tableIdentifier,
int pageNumber,
int pageSize
)
Public Function ExecuteQuery (
sqlQuery As String,
parameters As Hashtable,
tableIdentifier As String,
pageNumber As Integer,
pageSize As Integer
) As DataSet
Parameters
- sqlQuery
- Type: SystemString
A select SQL query - parameters
- Type: System.CollectionsHashtable
A collection of parameters - 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
Return Value
Type:
DataSetThe loaded dataset
See Also