Hi all,

I'm creating some custom web parts that pull data from SQL Server and display the data via a DataGrid. What's the best approach for persisting the data retrieved from SQL so that the query doesn't have to be re-run every time the user clicks just about anything on the page? For example, if I have two web parts on the page, the user clicks on the header of a grid in one of them to sort on that column, both web parts are rebuilt completely (or at least, so it seems) so that the web part class is initialized and the data is pulled again.

How is this typically handled on the web in general? Control State? View State? Session Ojbects?

TIA,
Chad