How to handle large volume of data in gridview?

Question

Hi all,

I have large volume of records in my database(70k).How do i handle with this kind of volume data in gridview.

Is there any samples provided for this?

Answer 1

use a proper virtualizing datagrid - not the one coming from Microsoft.

Either do it yourself, or buy (Infragistics, Devexpress, Telerik, thy all can do that).

Answer 2

Restrict the GridView to showing 10 or 20 items per page and then rewrite your data access layer so that you can request pages of data from the database. You can then create your own paging buttons and request the proper page of data as the user clicks on each page.

Allowing the user to enter search criteria to reduce the number of rows returned from the database would also be a good option.