How to fatch Next 10 record from Particular Id

Question

How to fatch Next 10 record from Particular Id In Asp.net MVC Web Api

Manas Mohapatra · Answer

You can implement in Database or C# side. Follow below code: In SQL Server 2012 prior version: DECLARE @PageNumber AS INT , @RowspPage AS INT SET @PageNumber = 2; SET @RowspPage = 5; SELECT * FROM ( SELECT ROW_NUMBER() OVER( ORDER BY ID_EXAMPLE) AS NUMBER, ID_EXAMPLE, NM_EXAMPLE, DT_CREATE FROM TB_EXAMPLE ) AS TBL WHERE NUMBER BETWEEN ((@PageNumber - 1) * @RowspPage + 1) AND (@PageNumber * @RowspPage) ORDER BY ID_EXAMPLE; If you are using Microsoft SQL Server 2012 then: -- You need to make it dynamic by using variables. SELECT * FROM TableName ORDER BY id OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY ; Using Linq: var pageSize = 10; // set your page size, which is number of records per page var page = 1; // set current page number, must be >= 1 var skip = pageSize * (page-1); Phrases = bannersPhrases.Select(p => p.Phrase) .Skip(skip) .Take(pageSize) .ToArray();

Dr.Ajay Kashyap · Answer

Thanks Manas Mohapatra sir....

Dr.Ajay Kashyap · Answer

i have 100 records in my table from that at first payload i fetched first 10 record which are 1 to 10 ; In second payload i want to fetch next 10 record from id 11 to 20 ; then third payload i want to fetch next 10 record from id 21 to 30

Manas Mohapatra · Answer

Please describe your requirement more with an example.

How to fatch Next 10 record from Particular Id

Answers (4)