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: 9.0.3.0 (9.0.3.20240719)

Syntax

Copy

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: DataSet
The loaded dataset

Reference

DataAccess Class

ExecuteQuery Overload

WorkflowGen.My.Data Namespace

DataAccessAddLanguageSpecificTextSet("LST8B619D0E_0?cpp=::|nu=.");ExecuteQuery Method (String, Hashtable, String, Int32, Int32)

Parameters

Return Value

Reference

DataAccessExecuteQuery Method (String, Hashtable, String, Int32, Int32)