I know in asp.net 1.0 the grid display controls would pull all the data in, and then provide paging but the paging was done in memory.
Are there any smarter controls that provide paging where they only pull the data relevent to current page being displayed?
ie. select 10 rows for the current page, instead of doing a select of ALL the rows in the table.