Thanks for your answer Andrew,
I checked the samples this morning. From what i understand, you bind the grid to a subset of your results (the SQL query returns the top-N items). Problem is that I have to calculate totals for the whole query and place them in the column footers of the grid. To calculate those totals, I referred to one of the samples: I use the ItemDataBound, ItemCreated and DataBound event of the grid. It is working fine as I return the full dataSet. Problem is that if i implement the paging as you suggest, I will have only a subset of data to work with... hence the totals won't be correct.
Is there a way to bind the grid to the full dataSet but display only a subset of rows ? That I think could solve my problems.
Regards,
Pascal