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 Kumar 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/