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.