Loading

How to display specific data to sql server ?

Sandeep Kumar

10y814

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
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);