DataAccessFillTableFromQuery 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: 8.0.6.0 (8.0.6.20210916)
Syntax public void FillTableFromQuery(
string sqlQuery,
Hashtable parameters,
DataSet dataSet,
string tableIdentifier,
int pageNumber,
int pageSize
)
Public Sub FillTableFromQuery (
sqlQuery As String,
parameters As Hashtable,
dataSet As DataSet,
tableIdentifier As String,
pageNumber As Integer,
pageSize As Integer
)
Parameters
- sqlQuery
- Type: SystemString
A select SQL query - parameters
- Type: System.CollectionsHashtable
A collection of parameters - 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
See Also