Wednesday May 04, 2005

Stored procedure for Custom Paging

we already know that dataGrid control has built in paging feature. but there are some situation that we have to turn our mind to custom paging. Reason is that if we are binding 100000+ records to a DataSet we wont be showing al those records at once. If we use built in paging we are just binding the complete dataset to the datagrid at once. this will lead to a performance overhead becuase we have to bind the dataset al the time. what if we can pull out only the records we need & give options to the user to browse through the pages. All we have to do it write a StoredProcedure which returns required records. Check the out the Article beclow. you find it interesting i bet u do. Happy Programming!

Custom Paging with Stored Procedure