Kentico 9.0 API Reference
Namespaces
CMS.Helpers
DataHelper Class
DataHelper Methods
CompareByteArrays Method
ConvertColumnToDateTime Method
ConvertToDataTable(T) Method
ConvertValue Method
ConvertValueToDefaultCulture Method
CopyColumnValues Method
CreateUniqueTableColumn Method
DataSetPivot Method
DataSourceIsEmpty Method
DeleteRows Method
EnsureCodenames Method
EnsureColumn Method
EnsureGUIDs Method
EnsureIdentifiers Method
EnsureRandomValues Method
EnsureStringValues Method
ExtendParameters Method
FileSizeFormat Method
ForEachRow Method
FromBase64String Method
GetBoolValue Method
GetColumns 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
GetTopNForPage Method
GetUniqueRows Method
GetUniqueValues Method
GetValues(T) Method
GetValuesFrequency Method
GetViewSize Method
ChangeBooleanValues Method
ChangeStringValues Method
ChangeValuesToNull Method
IsEmpty Method
IsValid Method
IsValidID Method
IsZero Method
KeepOnlyRows Method
LockDataSet Method
LowerCaseTableNames Method
MarkDuplicitRows Method
Merge(T, K, V) Method
MergeHashtables Method
ReadDataSetFromXml Method
RecomputeChildCount Method
ReduceDataSetData Method
RenameTable Method
RestrictRows Method
SelectRowsByString Method
SetColumnValues Method
SetDataRowValue Method
SetPartialValue Method
SetTableName Method
ShiftValuesUp Method
SortDataTable Method
TransferTable Method
TransferTableRows Method
TransferTables Method
TranslateBinaryColumn Method
TrimDataSetPage Method
TrimLastIdFromList 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: 9.0.0
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