We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to resolve the filtering issue in WinForms GridControl?

Platform: WinForms |
Control: GridControl

Restrict the filtering issue

The Filter bar can be added to the virtual grid of the GridControl when you set BrowseOnly or ReadOnly to the grid, you cannot filter using the filter bar because BrowseOnly is also applied to the filter bar. To resolve this, use the following method.


Instead of setting ReadOnly or BrowseOnly, you can cancel the cell editing for the all the cells except the Filter bar row by setting e.cancel as True in the CurrentCellStartEditing event. The following code example is for cancelling the row.


//Hooking Currentcell startEditing event.
this.gridControl1.CurrentCellStartEditing += new CancelEventHandler(gridControl1_CurrentCellStartEditing);
void gridControl1_CurrentCellStartEditing(object sender, CancelEventArgs e)
    GridCurrentCell cc = this.gridControl1.CurrentCell;
    if (cc != null && cc.RowIndex != 1 && cc.ColIndex > 0)
        //Cancel editing process except filterbar and rowheader before it starts.
        e.Cancel = true;


'Hooking Currentcell startEditing event.
Private Me.gridControl1.CurrentCellStartEditing += New CancelEventHandler(AddressOf gridControl1_CurrentCellStartEditing)
Private Sub gridControl1_CurrentCellStartEditing(ByVal sender As Object, ByVal e As CancelEventArgs)
 Dim cc As GridCurrentCell = Me.gridControl1.CurrentCell
 If cc IsNot Nothing AndAlso cc.RowIndex <> 1 AndAlso cc.ColIndex > 0 Then
  'cancel editing process except filterbar and rowheader before it starts.
  e.Cancel = True
 End If
End Sub


C#: GridControlFilterBar_CS

VB: GridControlFilterBar_VB


2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile