SqlHelper.GetData Method

Note: This API is now obsolete.

Gets the data from the DataSet

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 8.2.23

Syntax

[ObsoleteAttribute("Use new MemoryDataQuerySource(sourceData).GetData(parameters)")]
public static DataSet GetData(
	DataSet sourceData,
	QueryDataParameters parameters,
	string where,
	string orderBy,
	int topN,
	string columns,
	int offset,
	int maxRecords,
	ref int totalRecords
)

Parameters

sourceData

Type: System.Data.DataSet
Source data

parameters

Type: CMS.DataEngine.QueryDataParameters
Query data parameters

where

Type: System.String
WHERE expression

orderBy

Type: System.String
Sort expression

topN

Type: System.Int32
Top N expression

columns

Type: System.String
Columns expression

offset

Type: System.Int32
Index of first record to get

maxRecords

Type: System.Int32
Maximum number of records to get. If maxRecords is zero or less, all records are returned (no paging is used)

totalRecords

Type: System.Int32
Returns total records

Return Value

Type: DataSet