FilterControl.SetFilterColumnsCollection(FilterColumnCollection) Method

Creates filter columns.

Namespace: DevExpress.XtraEditors

Assembly: DevExpress.XtraEditors.v19.2.dll

Declaration

C#

public void SetFilterColumnsCollection(
    FilterColumnCollection columns
)

VB.NET

Public Sub SetFilterColumnsCollection(
    columns As FilterColumnCollection
)

Parameters

Name	Type	Description
columns	DevExpress.XtraEditors.Filtering.FilterColumnCollection	A DevExpress.XtraEditors.Filtering.FilterColumnCollection object that represents the collection of filter columns.

Remarks

The Filter Control is mainly designed to operate with the source control which is assigned via the FilterControl.SourceControl property. In this instance, after a source control has been assigned to the Filter Control, the filter columns are automatically retrieved from the source control. If the source control isn’t specified, these should be defined manually. To do this, use the SetFilterColumnsCollection method.

The SetFilterColumnsCollection method clears the Filter Control‘s FilterControl.FilterColumns collection and populates it with columns retrieved from the columns parameter.To view an example, see the ‘Filter Control’ module in the XtraGrid’s Main Demo.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SetFilterColumnsCollection(FilterColumnCollection) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

filtercontrol-how-to-remove-brackets-from-the-column-element-name-e5026/CS/Q264421/Form1.cs#L19

columns.Add(new UnboundFilterColumn("Discount", "Discount", typeof(decimal), spinEdit, FilterColumnClauseClass.Generic));
filterControl.SetFilterColumnsCollection(columns);
filterControl.FilterCriteria = CriteriaOperator.Parse("Product between ('Alice Munton', 'Icura') && Discount > .05");

how-to-implement-custom-painting-in-filtercontrol-e2332/CS/Q264421/Main.cs#L20

columns.Add(new UnboundFilterColumn("Discount", "Discount", typeof(decimal), spinEdit, FilterColumnClauseClass.Generic));
filterControl.SetFilterColumnsCollection(columns);
filterControl.FilterCriteria = CriteriaOperator.Parse("Product between ('Alice Munton', 'Icura') && Discount > .05");

how-to-implement-custom-range-editing-in-the-filtercontrol-e474/CS/WindowsApplication197/Form1.cs#L34

columnCollection["ID"].SetColumnEditor(new RepositoryItemCalcEdit());
filterControl1.SetFilterColumnsCollection(columnCollection);

VB.NET

filtercontrol-how-to-remove-brackets-from-the-column-element-name-e5026/VB/Q264421/Form1.vb#L21

columns.Add(New UnboundFilterColumn("Discount", "Discount", GetType(Decimal), spinEdit, FilterColumnClauseClass.Generic))
filterControl.SetFilterColumnsCollection(columns)
filterControl.FilterCriteria = CriteriaOperator.Parse("Product between ('Alice Munton', 'Icura') && Discount > .05")

how-to-implement-custom-painting-in-filtercontrol-e2332/VB/Q264421/Main.vb#L22

columns.Add(New UnboundFilterColumn("Discount", "Discount", GetType(Decimal), spinEdit, FilterColumnClauseClass.Generic))
filterControl.SetFilterColumnsCollection(columns)
filterControl.FilterCriteria = CriteriaOperator.Parse("Product between ('Alice Munton', 'Icura') && Discount > .05")

how-to-implement-custom-range-editing-in-the-filtercontrol-e474/VB/WindowsApplication197/Form1.vb#L33

columnCollection("ID").SetColumnEditor(New RepositoryItemCalcEdit())
filterControl1.SetFilterColumnsCollection(columnCollection)