DataAccess.FillTableFromQuery Method (String, DataSet, String, Int32, Int32, Boolean)

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

Load the specified table of a given dataset with the results of the specified select SQL query

Namespace: WorkflowGen.My.Data
Assembly: WorkflowGen.My (in WorkflowGen.My.dll) Version: 3.3.0.0 (3.3.0.0)

Syntax

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

DataAccess Class

FillTableFromQuery Overload

WorkflowGen.My.Data Namespace