DataAccessFillTableFromQuery Method (String, 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: 9.1.0.0 (9.1.0.20241025)
Syntax public void FillTableFromQuery(
string sqlQuery,
DataSet dataSet,
string tableIdentifier,
int pageNumber,
int pageSize
)
Public Sub FillTableFromQuery (
sqlQuery As String,
dataSet As DataSet,
tableIdentifier As String,
pageNumber As Integer,
pageSize As Integer
)
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
See Also