10000 record display GridView in paging with 1000 using sql.

Question

One Table Employee : Record Of 100000 I can display this record in gridview in paging nation of 1000. Provide Next and Privious button . Fist Time load data in 1 to 1000 than after click next button to show 1001 to 2000 record using SQL SERVER Procedure. So Please Help me.

Manish Kumar · Answer

Hi Viral Use offset and fetch for pagination in sql server . Other alternate is use row number and pass the row number in @from and @to. Thanks

Amit Singh · Answer

hey refer this 1.http://www.aspsnippets.com/Articles/Custom-Paging-in-ASPNet-GridView-using-SQL-Server-Stored-Procedure.aspx 2.http://www.c-sharpcorner.com/UploadFile/99bb20/custom-paging-with-gridview-control-in-Asp-Net-4-5/