Click or drag to resize
DataAccess.FillTableFromQuery Method (String, Hashtable, DataSet, String, Int32, Int32)
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: 2.4.0.0 (2.4.0.0)
Syntax
public void FillTableFromQuery(
	string sqlQuery,
	Hashtable parameters,
	DataSet dataSet,
	string tableIdentifier,
	int pageNumber,
	int pageSize
)

Parameters

sqlQuery
Type: System.String
A select SQL query
parameters
Type: System.Collections.Hashtable
A collection of parameters
dataSet
Type: System.Data.DataSet
The dataset to fill
tableIdentifier
Type: System.String
A table name identifier
pageNumber
Type: System.Int32
The record number to start with
pageSize
Type: System.Int32
The number of records per page
See Also