DataHelper Class

Methods to work with the Data.

Inheritance Hierarchy

System.Object
  CMS.Base.CoreMethods
    CMS.Helpers.DataHelper

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

Syntax

public class DataHelper : CoreMethods

The DataHelper type exposes the following members.

Constructors

	Name	Description
Public method	DataHelper

Fields

	Name	Description
Public field Static member	FAKE_ID	Fake ID to use when the ID column requires a value, and needs to be faked

Methods

	Name	Description
Public method Static member	ChangeBooleanValues(DataTable, String, Boolean, String)	Changes the boolean value in the given table.
Public method Static member	ChangeBooleanValues(DataTable, String, Boolean, Boolean, String)	Changes the boolean value in the given table.
Public method Static member	ChangeStringValues	Changes the string value in the given table.
Public method Static member	ChangeValuesToNull	Changes the value in the given table to NULL.
Public method Static member	CompareByteArrays	Compares two byte arrays.
Public method Static member	ConvertToDataTable<T>	Method to convert LINQ result to DataTable
Public method Static member	ConvertValue(Object, Type)	Converts the value to a specific type.
Public method Static member	ConvertValue(Object, Type, Object)	Converts the value to a specific type. Returns true if conversion was possible, otherwise false.
Public method Static member	ConvertValueToDefaultCulture	Converts value to its equivalent string representation using default culture format. Can be used to convert Double, Decimal, DateTime or TimeSpan values.
Public method Static member	CreateUniqueTableColumn	Creates column with unique name int he given table.
Public method Static member	DataSetPivot	Converts data set to it's pilot.
Public method Static member	DataSourceIsEmpty(DataSet)	Returns true if the given data source is empty.
Public method Static member	DataSourceIsEmpty(Object)	Returns true if the given data source is empty.
Public method Static member	DeleteRows(DataSet, String)	Deletes the table rows matching the given where condition.
Public method Static member	DeleteRows(DataTable, String)	Deletes the table rows matching the given where condition.
Public method Static member	EnsureColumn	Ensures specified column.
Public method Static member	EnsureGUIDs	Ensures GUID values in specified column.
Public method Static member	ExtendParameters	Extends the parameters array for new items.
Public method Static member	ForEachRow(DataSet, Action<DataRow>, Func<DataRow, Boolean>)	Executes the given action for each row in the given DataSet
Public method Static member	ForEachRow(DataTable, Action<DataRow>, Func<DataRow, Boolean>)	Executes the given action for each row in the given DataSet
Public method Static member	GetBoolValue(ISimpleDataContainer, String)	Gets the bool variable from given data container.
Public method Static member	GetBoolValue(DataRow, String, Boolean)	Gets the bool variable from given DataRow.
Public method Static member	GetBoolValue(ISimpleDataContainer, String, Boolean)	Gets the bool variable from given data container.
Public method Static member	GetDataContainer	Gets the data container able to read the given data object
Public method Static member	GetDataContainerItem	Returns data from datarow, datarowview or ISimpleDataContainer objects for specified column.
Public method Static member	GetDataRowValue	Returns the value from the DataRow field, or DBNull.Value if the field does not exist in the datarow.
Public method Static member	GetDataRowViewValue	Returns the value from the DataRowView field, or null if the field does not exist in the datarow.
Public method Static member	GetDataSetFromXml	Gets DataSet from the given XML string.
Public method Static member	GetDataTable	Returns the DataTable from the given data source.
Public method Static member	GetDataView	Returns the DataView from the given data source.
Public method Static member	GetDateTimeValue(ISimpleDataContainer, String)	Gets the DateTime variable from given data container.
Public method Static member	GetDateTimeValue(DataRow, String, DateTime)	Gets the DateTime variable from given DataRow.
Public method Static member	GetDBNull	Converts the standard null value to DBNull.value, keeps the object value if not null.
Public method Static member	GetGuidValue(ISimpleDataContainer, String)	Gets the guid variable from given data container.
Public method Static member	GetGuidValue(DataRow, String, Guid)	Gets the guid variable from given DataRow.
Public method Static member	GetIntegerValues	Gets the array of integer values from the given data table.
Public method Static member	GetIntValue(ISimpleDataContainer, String)	Gets the integer variable from given Data container.
Public method Static member	GetIntValue(DataRow, String, Int32)	Gets the integer variable from given DataRow.
Public method Static member	GetItemsCount	Gets the items count in the specified data source.
Public method Static member	GetMaximumValue<T>(DataTable, String)	Gets the maximum value from the given column.
Public method Static member	GetMaximumValue<T>(DataView, String)	Gets the maximum value from the given column.
Public method Static member	GetMinimumValue<T>	Gets the minimum value from the given column.
Public method Static member	GetNewItemsInList(String, String)	Gets the list of new items in the given list as list separated by semicolon.
Public method Static member	GetNewItemsInList(String, String, Char)	Gets the list of new items in the given list as list separated by separator.
Public method Static member	GetNotEmpty	Returns second parameter if the first is null or "".
Public method Static member	GetNotZero	Returns the object converted to integer or default value when the result of conversion equals zero.
Public method Static member	GetNull	Converts the DBNull.value to standard null, keeps the object value if not null.
Public method Static member	GetObjectSize	Gets the size of the given object.
Public method Static member	GetObjectString(Object, Int32)	Gets the object as a string (for structured objects the object type and its size).
Public method Static member	GetObjectString(Object, Int32, Int32)	Gets the object as a string (for structured objects the object type and its size).
Public method Static member	GetParentPath	Returns the parent path for the specified path (any kind of path with "/" as a separator)
Public method Static member	GetPartialValue	Gets value from string that has values separated by separator.
Public method Static member	GetRowSize	Returns the row data size (size of the contained data).
Public method Static member	GetScalarValue	Gets the first value from the given DataSet.
Public method Static member	GetSingleColumnDataSet	Returns a DataSet containing single table with single column.
Public method Static member	GetSizeString	Returns the string for the specified file size.
Public method Static member	GetStringValue(ISimpleDataContainer, String)	Gets the string variable from given data container.
Public method Static member	GetStringValue(DataRow, String, String)	Gets the string variable from given DataRow.
Public method Static member	GetStringValues	Gets the array of string values from the given data table.
Public method Static member	GetTableSize	Returns the table data size (size of the contained data).
Public method Static member	GetUniqueRows	Gets the list of unique rows based on given column value.
Public method Static member	GetUniqueValues	Gets the list of unique values based on given column value.
Public method Static member	GetValues<T>	Gets the array of the values from the given data table.
Public method Static member	GetValuesFrequency(DataTable, String)	Gets frequency of values in specified data table's column.
Public method Static member	GetValuesFrequency<TDataContainer>(IEnumerable<TDataContainer>, Func<TDataContainer, Object>)	Gets frequency of values in data collection.
Public method Static member	GetViewSize	Returns the view data size (size of the contained data).
Public method Static member	IsEmpty	Returns true, if the given value is empty (null, DBNull, or "").
Public method Static member	IsValidID	Returns true if the given value is a valid ID
Public method Static member	IsZero	Returns true, if the given value is zero (null, DBNull, or 0).
Public method Static member	KeepOnlyRows	Keeps only table rows matching the given where condition.
Public method Static member	LockDataSet	Makes the given DataSet read-only
Public method Static member	LowerCaseTableNames	Converts the table names of given DataSet to lowercase representation.
Public method Static member	MarkDuplicitRows	Marks the duplicate rows in the data table.
Public method Static member	Merge<T, K, V>	Merges two objects implementing the IDictionary interface of type T with key of type K and value of type V.
Public method Static member	ParseJsonValue	Parses given value treated as value from JSON, and converts it to given type.
Public method Static member	ParseXmlValue	Parses given value treated as value from XML, and converts it to given type.
Public method Static member	ReadDataSetFromXml(DataSet, XmlReader, Object[], String)	Reads the DataSet from given XML reader (expects "NewDataSet" as a root node).
Public method Static member	ReadDataSetFromXml(DataSet, XmlReader, Object[], String, List<String>, String)	Reads the DataSet from given XML reader.
Public method Static member	RecomputeChildCount	Re-computes count of child objects in parentObjects data table's childCountColumn column.
Public method Static member	ReduceDataSetData	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)
Public method Static member	RenameTable	Renames the table in the given DataSet.
Public method Static member	RestrictRows(DataSet, Int32)	Restricts the number of rows to the top N items.
Public method Static member	RestrictRows(DataSet, Int32, Int32, Int32)	Restricts the given DataSet to only given rows starting with the offset, and leaving only maximum defined number of rows.
Public method Static member	SetColumnValues	Sets column values to specified value.
Public method Static member	SetDataRowValue	Sets value to data row. If value is null, DBNull will be used.
Public method Static member	SetPartialValue	Sets new value to string that is separates by separator.
Public method Static member	SetTableName	Sets the table name in the specified DataSet.
Public method Static member	SortDataTable	Sorts the Data table using given OrderBy expression.
Public method Static member	TransferTable	Transfers tables from source DataSet to the destination DataSet and sets the source table name to specified value.
Public method Static member	TransferTableRows	Transfers table rows between two tables.
Public method Static member	TransferTables	Transfers tables from source DataSet to the destination DataSet.
Public method Static member	TrimDataSetPage	Trims first data table from source to fit into page.
Public method Static member	TryGetDataRowValue	Returns the value from the DataRow field.
Public method Static member	TryGetDataRowViewValue	Returns the value from the DataRowView field.
Public method Static member	Union	Creates the union of two Datasets, the values are compared for uniqueness by the given ID column name.
Public method Static member	WriteDataSetToXml	Writes the DataSet from given XML reader.