DataAccessFillTableFromQuery Method (String, DataSet, String, Int32, Int32, Boolean)

public void FillTableFromQuery(
	string sqlQuery,
	DataSet dataSet,
	string tableIdentifier,
	int pageNumber,
	int pageSize,
	bool countTotalRows
)

Public Sub FillTableFromQuery ( 
	sqlQuery As String,
	dataSet As DataSet,
	tableIdentifier As String,
	pageNumber As Integer,
	pageSize As Integer,
	countTotalRows As Boolean
)

Parameters

sqlQuery

Type: SystemString
A select SQL query

dataSet

Type: System.DataDataSet
The dataset to fill

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

Reference