Paging through lots of data

<i><b>Originally posted by : Jeffrey Bradshaw (jeffrey.bradshaw@Dictaphone.com)</b></i><br /><br />I have found how to have a datagrid 'page' through data for a large dataset (could be in the thousands of records). My question is, is that dataset stored on the server - or is it recalculated everytime or what? My query (which is a stored procedure or a view depending on what I'm doing) could take a while to execute so I want to do it only once.<br /><br />TIA - Jeffrey.

Just try it out then you 'll know! Microsoft usually bufferst the data on the client, anyway.