Gridview - Is it necessary to grab data from database every time a filter, sort, or paging event occurs?

Question

Regarding gridviews that are not bound to a Data Source Control:

In most GridView tutorials that I have seen, when just about any GridView event occurs, the end of the event handler will include BindDataGrid().

In some form, these BindDataGrid() functions 1) Grab data from the database 2) Assign any Filter or Sort expressions to the data, and 3) Bind the gridview to that data source (usually a DataView or DataTable.

Is there a better way to provide filterable & sortable data to a GridView without having to hit the database so often?

Thanks

Answer 1

You could use jquery ? :-)

Answer 2

hi

check this article which help you to achieve function you want : http://www.codeproject.com/KB/custom-controls/EnhanceGrid.aspx

Answer 3

Use either Database Caching or Output Caching, otherwise you will have to pull from the database often.