Wisej.NET Extensions
HomeNewsSupportVideos
  • Overview
  • Introduction
    • Extension Types
    • API
    • Concepts
    • Theme Builder
  • Icon Packs
    • Overview
    • BootstrapIcons
    • ElegantIcons
    • FontAwesome
    • MaterialDesign
    • ModernUI
    • VaadinIcons
    • VisualStudioIcons
  • Extensions
    • Themes
    • AceEditor
      • API
        • AceEditor
    • Amazon S3
      • API
        • S3FileSystemProvider
    • ASPNetControl
      • API
        • AspNetWrapper<T>
        • AspNetWrapperBase
        • HttpModule
        • HttpModuleStartup
    • Barcode
      • API
        • Barcode
        • BarcodeReader
        • BarcodeType
        • ScanEventArgs
        • ScanEventHandler
        • ScanMode
    • BingWallpaper
      • API
        • BingWallpaper
    • Brotli
      • API
        • Brotli
    • Bubbles
      • API
        • BubbleEventArgs
        • BubbleNotification
        • BubbleStyle
    • Camera
      • API
        • Camera
        • CameraErrorEventArgs
    • ChartJS
      • API
        • ChartClickEventArgs
        • ChartClickEventHandler
        • ChartJS
        • ChartType
        • DataLabelAlign
        • DataLabelAnchor
        • DataLabelTextAlignment
        • DataSet
        • DataSetCollection
        • OptionsAxisGridLines
        • OptionsBase
        • OptionsDataLabel
        • OptionsLegend
        • OptionsScales
        • OptionsTitle
        • OptionsTooltips
        • PointStyle
        • ScaleType
        • SteppedLine
    • Chat Control
      • API
    • CKEditor
      • API
        • CKEditor
        • CommandEventArgs
        • ExternalPlugin
        • LinkClickedEventArgs
    • ClearScript
      • API
        • ClearScript
        • EngineType
        • JScriptEngine
        • V8JavaScriptEngine
        • VBScriptEngine
    • ClientClipboard
      • API
    • ClientFileSystem
      • API
    • ColumnFilter
      • API
        • ColumnFilter
        • ColumnFilterPanel
        • SimpleColumnFilterPanel
        • WhereColumnFilterPanel
    • CoolClock
      • API
        • CoolClock
        • CoolClockSkin
        • CoolClockType
    • CountUp
      • API
        • CountUp
    • CustomWallpaper
      • API
        • CustomWallpaper
    • DataGridViewSummaryRow
      • API
        • DataGridViewSummaryRow
        • DataGridViewSummaryRowExtensions
        • SummaryType
    • FullCalendar
      • API
        • BusinessHours
        • ColumnHeaderFormats
        • DayClickEventArgs
        • Event
        • EventClickEventArgs
        • EventCollection
        • EventValueEventArgs
        • FullCalendar
        • ItemDropEventArgs
        • Resource
        • ResourceEventArgs
        • RetrieveVirtualEventEventArgs
        • ThemeSystem
        • ViewType
        • VirtualEventsNeededEventArgs
    • Geolocation
      • API
        • Geolocation
        • StatusCode
    • GoogleMaps
      • API
        • GeocoderLocationType
        • GeocoderResult
        • GoogleMap
        • LatLng
        • LatLngBounds
        • MapMouseEventArgs
        • MapPropertyChangedEventArgs
        • MarkerDragEventArgs
        • TravelMode
    • Html2Canvas
      • API
        • Html2Canvas
        • Html2CanvasOptions
    • jQueryKnob
      • API
        • Knob
        • KnobType
        • LineCapType
    • jSequence
      • API
        • ElementClickEventArgs
        • Sequence
    • JustGage
      • API
        • CustomSector
        • JustGage
    • NavigationBar
      • API
        • NavigationBar
        • NavigationBarItem
        • NavigationBarItemClickEventArgs
        • NavigationBarItemCollection
    • Notification
      • API
        • Notification
        • NotificationClickEventArgs
    • OfficeViewer
      • API
        • OfficeViewer
    • Pannellum
      • API
        • Pannellum
    • Polymer
      • API
        • PolymerComponent
        • PolymerWidget
    • ProgressCircle
      • API
        • ProgressCircle
    • RibbonBar
      • API
        • RibbonBar
        • RibbonBarAppButton
        • [RibbonBarCollectionBase<TOwner, TElement>](extensions/ribbonbar/api/wisej.web.ext.ribbonbar.ribbonb
        • RibbonBarGroup
        • RibbonBarGroupCollection
        • RibbonBarGroupEventArgs
        • RibbonBarItem
        • RibbonBarItemButton
        • RibbonBarItemButtonGroup
        • RibbonBarItemCheckBox
        • RibbonBarItemCollection
        • RibbonBarItemComboBox
        • RibbonBarItemControl
        • RibbonBarItemEventArgs
        • RibbonBarItemRadioButton
        • RibbonBarItemSeparator
        • RibbonBarItemSplitButton
        • RibbonBarItemTextBox
        • RibbonBarMenuItemEventArgs
        • RibbonBarPage
        • RibbonBarPageCollection
    • SideButton
      • API
        • SideButton
    • Signature
      • API
        • Signature
    • SmoothieChart
      • API
        • DataNeededEventArgs
        • InterpolationType
        • SmoothieChart
        • TimeSeries
        • TimeSeriesCollection
    • Speech
      • API
        • SpeechRecognition
        • SpeechRecognitionEventArgs
        • SpeechRecognitionResult
        • SpeechSynthesis
    • TaskBar
      • API
        • TaskBar
    • Tesseract
      • API
        • Tesseract
    • TinyEditor
      • API
        • TinyEditor
    • TinyMCE
      • API
        • TinyMCE
    • TourPanel
      • API
        • TourPanel
        • TourPanelEventArgs
        • TourStep
    • Translation
      • API
        • Translation
        • TranslationProviderBase
        • TranslationProviderYandex
        • TranslationResult
    • WebARIA
      • API
        • ARIA
        • Invalid
        • TriState
        • WebARIA
    • WebAuthn
      • API
        • Assertion
        • AttestationConveyancePreference
        • AuthenticatorAttachment
        • AuthenticatorData
        • AuthenticatorSelectionCriteria
        • AuthenticatorTransport
        • ClientData
        • COSEAlgorithmIdentifier
        • CredentialsResponse
        • PublicKey
        • PublicKeyCredentialDescriptor
        • PublicKeyCredentialParameters
        • PublicKeyCredentialUserEntity
        • RelyingParty
        • ResidentKeyRequirement
        • WebAuthn
    • WebShare
      • API
        • WebShare
    • XTerm
      • API
        • XTerm
  • Premium Extensions
    • Overview
    • Configuration
    • Webix
    • Syncfusion EJ1
    • Syncfusion EJ2
    • Telerik KendoUI
    • Infragistics IgniteUI
    • DevExpress DevExtreme
Powered by GitBook
On this page
  • Features
  • How to Use
  • WhereColumFilter
  • SimpleColumnFilter

Was this helpful?

  1. Extensions

ColumnFilter

PreviousAPINextAPI

Last updated 2 years ago

Was this helpful?

The ColumnFilter extender component allows you to add row filtering to your DataGridViews. It includes 2 ready made FilterPanels.

Features

Supports three kinds of column filters

  1. SimpleColumnFilter. Displays a list of all distinct values of the column

  2. WhereColumnFilter. Lets you set up Where conditions depending on the DataType of the column.

  3. CustomColumnFilter. You build your own filter panel.

How to Use

The ColumnFilter extension can be added to a Wisej project using NuGet Package Manager.

When using the WhereColumnFilter you need to also add a reference to System.Linq.Dynamic

You can set up a different image (or same image in a different color) that is displayed when the column is filtered.

WhereColumFilter

This filter panel adapts to the ValueType that has been set for the column and that determines which operators are displayed. Multiple conditions can be selected and users can control if those are combined with AND or OR.

SimpleColumnFilter

You can also use the ColumnFilter extension filter as a base to implement your own custom filter by providing code to the following events or override the functions:

Event/Function
Usage

Load

Fired when the ColumnFilter loads (just once). Can be used for initalizations.

BeforeShow

Fired everytime before the Panel is actually shown. Load values or set up conditions..

AfterShow

Fired everytime when the Panel is visible on the client. Populate lists.

ApplyFilters

Override to control the implementation of all your filters

ApplyFilter

Fired for each filter. Perform the actual filtering here.

RowsFiltered

Fired for each filter. Includes the number of visible rows in the event args.

More than one can be dropped on a DataGridView´s container.

The loads a list with all distinct values of the column. You can select/deselect multiple columns, select all, or clear the list.

We explained the source of the 2 default ColumnFilters in detail in our . You might also want to take a look at our ColumnFilter example in or .

ColumnFilter
SimpleColumnFilter
Blog
C#
VB.NET
wisej-extensions/Wisej.Web.Ext.ColumnFilter at 3.0 · iceteagroup/wisej-extensionsGitHub
ColumnFilter Source Code
Wisej-3-ColumnFilter 3.0.9nuget
Logo
Logo
ColumnFilters are shown as tool icons in the Column Headers.