Paging Implementation With SQL

When you see how the paging is a piece of cake now in .NET server controls (fro example, GridView), you can imagine how much amount of work was needed to do paging if you haven't these server controls. You can for example fetch all thr data block and put them on the session and just do your paging in you business layer! Ok..I heared someone say what are saying. Ture. This is really a miss when you working on huge data blocks. So, the best way is to do you paging inside the datalayer...