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.

//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 CurrentCellStartEditing event
AddHandler gridControl1.CurrentCellStartEditing, AddressOf gridControl1_CurrentCellStartEditing

Private Sub gridControl1_CurrentCellStartEditing(sender As Object, e As CancelEventArgs)
    Dim cc As GridCurrentCell = 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 the WinForms GridControl feature tour page to know about its other groundbreaking feature representations, WinForms GridControl documentation, and how to quickly get started for configuration specifications.

For current customers, you can check out our 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 other controls.

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