how to paginating data in advanced data grid view?

davidegironi / advanceddatagridview

A .NET WinForms DataGridView with advanced capabilities

392 stars 123 forks source link

how to paginating data in advanced data grid view? #130

Closed farshadvl closed 8 months ago

farshadvl commented 8 months ago

hi every body. I want to pagination data for best performance of my app form. so I want to do that and when user filter data I should show him all records not that paged records to choose data. how can I do that? Page Data But Show All Data in filter?!?

davidegironi commented 8 months ago

Hello, My suggestion is to filter that at Database to Dataset conversion, so it's something you have to do in the SQL (or any other filtering DB language) query, using LINQ to SQL or any other wrapper. You can take a look at the DentneD project, FormInvoices filter on top as example.