Need advices on my codes

[Danny Ni]

Hi,

I am using datagrid's paging feature. What I usually do is to use codes to
get a dataset from SQL server and put the dataset into session, and in
PageIndexChanged event handler I set the datagrid datasource to the dataset
in session.

Questions:
(1) Is this a good way? Or should I use the same codes to get dataset again
in PageIndexChanged event handler.
(2) When should I remove the dataset from session? This dataset is only
useful to this page only.

TIA