Hi Chad,

I haven't done much with Web apps lately, but when I was messing around with them a couple years back, I determined that the best way to persist data was with Session objects.

~~Bonnie



>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