How to display specific data to sql server ?

Question

Suppose in our database more than 5000 records are thereAnd we would like to display only 1-10 data from back end to front end. Then how we will display the specific record?

Manas Mohapatra · Answer

Use paging concept: In SQLServer http://sqlperformance.com/2015/01/t-sql-queries/pagination-with-offset-fetch In ASP.NET http://www.aspsnippets.com/Articles/Paging-in-ASPNet-GridView-Example.aspx In Linq int numberOfObjectsPerPage = 10; var queryResultPage = queryResult.Skip(numberOfObjectsPerPage * pageNumber).Take(numberOfObjectsPerPage);