large data set and 'Normal Filter'

[Gene Allen]

My dataset contains about 50,000 read-only records.

When the filter bar is clicked, it enumerates the dataset to populate the dropdown filter, which makes it slow (I believe this is referred to as the "Normal Filter").

I want to replace this behavior by having every column in the filter bar use a text-based search (e.g., contains, like, starts with, etc.) and hide the dropdown filter entirely.

I’ve figured out how to turn filtering off for a column, but I haven’t found a way to disable the "Normal Filter" specifically.

As a side note, I downloaded the Syncfusion samples from GitHub to explore potential solutions. However, the GridGroupingControl samples fail to compile because they use System.Data.SqlServerCE, which hasn't been supported since before .NET 5. I'm currently using .NET 8.

If one of the other grid types would work better, I'm fine with switching.  My working with auditing data so it's not sortable or editable, just searchable.

[Gene Allen]

I switching to a sfDataGrid and it's working more like what I except and hiding that 'Normal Filter'

[Malini Selvarasu]

Hi  Gene Allen,

We are pleased to hear that your issue was resolved by using the SfDataGrid. The SfDataGrid provides enhanced functionality compared to the GridGroupingControl, and we have recommended transitioning to this control for its advanced capabilities. It is a powerful and flexible solution, offering exceptional performance, a wide range of features, and the versatility required for modern application development. For additional information, please refer to the User Guide documentation below.

UG Link : Windows Forms DataGrid Control | Syncfusion

Should you have any further questions or require assistance with the SfDataGrid, please do not hesitate to reach out. We are always here to assist you.

Regards,

Malini Selvarasu