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

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

Public Function ExecuteQuery ( 
	sqlQuery As String,
	tableIdentifier As String,
	pageNumber As Integer,
	pageSize As Integer,
	countTotalRows As Boolean
) As DataSet

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

Reference