First of all why do we need to do our paging in the back end when all the data controls in ASP.NET provide paging technique?  The answer is simple, to improve the performance of the application. In small applications you many not find the difference, but in big applications where thousand to millions records need to be retrieved, Data controls pagination takes 2 – 5 minutes which is not acceptable at all, and even you may get out of memory. So it’s always a good idea to have your paging mechanism on the  backend. In this article i will explain the way how we can do our paging on backend by sending page Size & current Page.

Read More » » » »