How to do asp.net,C# custom paging like google using stored procedures with source code
This will give you some hints that How to do custom paging like google using stored procedures in asp.net and sql server 2008. Its pretty simple but logical as well. So i am placing my code which is simple to understand and you can modify it accordingly. Stored Procedure: Create PROCEDURE [dbo].[yourProcedurename] @StartingIndex int, @PageSize int AS BEGIN with Slice as ( select row_number() over(order by id desc) as displayRowNum,* from table_Name ) select * from Slice where displayRowNum between @StartingIndex and @StartingIndex+@PageSize; END C# Code: Set your current page to paging bar......