Archive for SQL Server 2005
Custom paging in Data Grid using C#.net
Posted by: | CommentsPagination is a good technique used to improve the performance of the application and usability. But it’s always not suitable to use the built-in pagination approach of Data Grid, in that case we may require to write our own custom paging. In this article i will explain implementing custom paging using Link Buttons, in this approach we will write our paging logic in the stored procedure to improve the performance of the application.
Data Pagination in the stored procedure
Posted by: | CommentsFirst 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.