[2008] Need Datagridview filtering advice

[Nitesh]

Hi Guys,

I have a datagridview that's taking a while to load because my table contains almost 5000 records. How can I provide an easy way for clients to filter the grid based on a product name. I was thinking of having labels with each alphabet on my form and when they click a label it filters the bindingsource according to the chosen alphabet. this seems like an awkward solution though. Can someone please give me a better idea. Thanks

[Deepak Sakpal]

See if VirtualMode helps in fast rendering of records.

Similar to your idea is Paging which we see in web applications where records are displayed page-wise. If you set Page Size to 10 then 10 records are displayed per page. So initially only 10 records will be fetched from Database. When you will click next page then the records for that page are displayed and so on. Paging feature is not supported by DataGridView control, you need to implement custom logic for that.

[Nitesh]

thanks for the reply Deepak. Virtualmode did nothing unfortunately. I like your paging idea . Will look into it now