How to restrict the filtering issue in WinForms GridControl?

Restrict the filtering issue

The Filter bar can be added to the virtual grid of the WinForms 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.

Solution

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.

C#

//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;
    }
}

VB

'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

Conclusion

I hope you enjoyed learning about how to resolve the filtering issue in WinForms GridControl.

You can refer to our WinForms Grid Control’s feature tour page to know about its other groundbreaking feature representations. You can also explore our WinForms Grid Control documentation to understand how to present and manipulate data.

For current customers, you can check out our WinForms components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our WinForms Grid Control and other WinForms components.

If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!