I create an empty cursor, append empty records equal related table at sql server. when user move page or jump anywhere at grid, fill empty records use with a code part from a thread from you and another developer from Europe (I'm not sure but maybe he was Walter Mester or another, sorry). That code part worked for me very well, thanks both of you.
Maybe this feature works faster but needs SQL 2012 is not a good idea. Customers at Turkey usually don't upgrade their's SQL SERVER's. You know, SQL SERVER is not a visual application and if it works, enough for them... My memory is hazy, but I vaguely recall that Walter Meester and I shared some messages and code for paging back in 2007-2008.
I understand the challenges of upgrading databases. It requires time and available people to go through the process. In the case of SQL 2012, they didn't add as much to the T-SQL language as they did in prior releases - one of the single biggest enhancements in the SQL 2012 is the columnstore index. The columnstore index can optimize some queries by a factor of 8-10 or more - that's huge, though it's only practical in data warehouse/data mart situations, not for OLTP databases.