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

Posted by hamlin11 on Stack Overflow See other posts from Stack Overflow or by hamlin11
Published on 2010-05-13T18:54:21Z Indexed on 2010/05/13 19:04 UTC
Read the original article Hit count: 387

Filed under:

ASP.NET

|

gridview

|

.NET

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

© Stack Overflow or respective owner

Related posts about ASP.NET

Migrating ASP.NET MVC 1.0 applications to ASP.NET MVC 2 RTM

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Note: ASP.NET MVC 2 RTM isn’t yet released! But this tool will help you get your ASP.NET MVC 1.0 applications ready for when it is! I have updated the MVC App Converter to convert projects from ASP.NET MVC 1.0 to ASP.NET MVC 2 RTM. This should be last the last major change to the MVC App Converter… >>> More
April 14th Links: ASP.NET, ASP.NET MVC, ASP.NET Web API and Visual Studio

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Here is the latest in my link-listing blog series: ASP.NET Easily overlooked features in VS 11 Express for Web: Good post by Scott Hanselman that highlights a bunch of easily overlooked improvements that are coming to VS 11 (and specifically the free express editions) for web development: unit… >>> More
Use ASP.NET 4 Browser Definitions with ASP.NET 3.5

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We updated the browser definitions files included with ASP.NET 4 to include information on recent browsers and devices such as Google Chrome and the iPhone. You can use these browser definition files with earlier versions of ASP.NET such as ASP.NET 3 Read More......(read more) >>> More
ASP.NET webforms + ASP.NET Ajax versus ASP.NET MVC and Ajax framework freedom

as seen on Stack Overflow - Search for 'Stack Overflow'
If given the choice, which path would you take? ASP.NET Webforms + ASP.NET AJAX or ASP.NET MVC + JavaScript Framework of your Choice Are there any limitations that ASP.NET Webforms / ASP.NET AJAX has vis-a-vis MVC? >>> More
ASP.NET MVC 2 Released

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I’m happy to announce that the final release of ASP.NET MVC 2 is now available for VS 2008/Visual Web Developer 2008 Express with ASP.NET 3.5. You can download and install it from the following locations: Download ASP.NET MVC 2 using the Microsoft Web Platform Installer Download… >>> More

Related posts about gridview

ASP.NET: Repeater with Button inside GridView: Call OnRowCommand of the GridView

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a asp:Repeater in one of my asp:GridView columns. In the template of the repeater I have a button. When that button is clicked, how can I get the OnRowCommand of the GridView to be called instead of the Repeater one? >>> More
Nesting gridview/formview in webuser control inside a parent gridview

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm developing an ASP.net 2 website for our HR department, where the front page has a matrix of all our departments against pay grades, with links in each cell to all the jobs for that department for that grade. These links take you a page with a gridview populated dynamically, as each department… >>> More
Display ASP.NET GridView inside a selected row in another GridView

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been given a mockup that I do not know is possible to code in ASP.NET without being a real html and javascript wizard. I want a GridView that when a row is selected, the selected row expands and below the selected row a panel of additional information is shown, which would also include another… >>> More
Even if GridView.DataKeyNames is set, Gridview.DataKeys[] is still empty

as seen on Stack Overflow - Search for 'Stack Overflow'
hi GridView.DataKeynames stores the names of the primary key fields for the items displayed in a GridView control. 1) Even though I’ve set DataKeyNames, GridView still doesn’t store record’s primary key value(s) in DataKey object: protected void SqlDataSource1_Selected(object sender, … >>> More
Find GridView Row from another gridview

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have 2 datagrid (using .net 1.1). I need to access column of second grid ( i need to make a column of second grid as disabled) when i click "Cancel" link button in First Grid. How can this be done? >>> More