DataHelper.ReduceDataSetData Method

Reduces the data set data. Works in two modes: 1 - remove records (when calculateAverage is FALSE) 2 - calculate average values for the intervals (when calculateAverage is TRUE)

Namespace: CMS.Helpers
Assembly: CMS.Helpers (in CMS.Helpers.dll) Version: 11.0.0

Syntax

public static DataSet ReduceDataSetData(
	DataSet ds,
	int keepEveryXItem,
	bool calculateAverage,
	string columnNames
)

Parameters

ds

Type: System.Data.DataSet
The input dataset

keepEveryXItem

Type: System.Int32
The keep every x-item

calculateAverage

Type: System.Boolean
if true: calculate average value for the interval. If false: pick every X-record

columnNames

Type: System.String
Calculate average values just for given columns (Column1;Column2..). If null, calculate for all columns of types integer and double.

Return Value

Type: DataSet