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

public DataSet ExecuteQuery(
	string sqlQuery,
	Hashtable parameters,
	string tableIdentifier,
	int pageNumber,
	int pageSize,
	bool countTotalRows
)

Public Function ExecuteQuery ( 
	sqlQuery As String,
	parameters As Hashtable,
	tableIdentifier As String,
	pageNumber As Integer,
	pageSize As Integer,
	countTotalRows As Boolean
) 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

countTotalRows

Type: SystemBoolean
A boolean which determines whether or not to count the total number of rows regardless the paging settings

Return Value

Reference