Xperience 13 API Reference
Namespaces
CMS Namespaces
CMS.Helpers Namespaces
CMS.Helpers
DataHelper Class
DataHelper Methods
ChangeBooleanValues Method
ChangeStringValues Method
ChangeValuesToNull Method
CompareByteArrays Method
ConvertToDataTable(T) Method
ConvertValue Method
ConvertValueToDefaultCulture Method
CreateUniqueTableColumn Method
DataSetPivot Method
DataSourceIsEmpty Method
DeleteRows Method
EnsureColumn Method
EnsureGUIDs Method
ExtendParameters Method
ForEachRow Method
GetBoolValue Method
GetDataContainer Method
GetDataContainerItem Method
GetDataRowValue Method
GetDataRowViewValue Method
GetDataSetFromXml Method
GetDataTable Method
GetDataView Method
GetDateTimeValue Method
GetDBNull Method
GetGuidValue Method
GetIntegerValues Method
GetIntValue Method
GetItemsCount Method
GetMaximumValue Method
GetMinimumValue(T) Method
GetNewItemsInList Method
GetNotEmpty Method
GetNotZero Method
GetNull Method
GetObjectSize Method
GetObjectString Method
GetParentPath Method
GetPartialValue Method
GetRowSize Method
GetScalarValue Method
GetSingleColumnDataSet Method
GetSizeString Method
GetStringValue Method
GetStringValues Method
GetTableSize Method
GetUniqueRows Method
GetUniqueValues Method
GetValues(T) Method
GetValuesFrequency Method
GetViewSize Method
IsEmpty Method
IsValidID Method
IsZero Method
KeepOnlyRows Method
LockDataSet Method
LowerCaseTableNames Method
MarkDuplicitRows Method
Merge(T, K, V) Method
ParseJsonValue Method
ParseXmlValue Method
ReadDataSetFromXml Method
RecomputeChildCount Method
ReduceDataSetData Method
RenameTable Method
RestrictRows Method
SetColumnValues Method
SetDataRowValue Method
SetPartialValue Method
SetTableName Method
SortDataTable Method
TransferTable Method
TransferTableRows Method
TransferTables Method
TrimDataSetPage Method
TryGetDataRowValue Method
TryGetDataRowViewValue Method
Union Method
WriteDataSetToXml Method
Click or drag to resize
DataHelperKeepOnlyRows Method
Keeps only table rows matching the given where condition.

Namespace: CMS.Helpers
Assembly: CMS.Helpers (in CMS.Helpers.dll) Version: 13.0.131
Syntax
C#
Copy
public static void KeepOnlyRows(
	DataTable dt,
	string where
)

Parameters

dt
Type: System.DataDataTable
Data table
where
Type: SystemString
Where condition
See Also