Aug 26, 2014 05:22 AM|George Hua - MSFT|LINK
As far as I know, you could create a Stored Procedure that allows us to pass page index and page size, it will return data source that we want to bind to gridview.
For more information about how to create this stored procedure, please have a look at
Stored Procedure with Sorting, Paging, and Filtering.
In addition, another solution may give you help:
Custom paging with ASP.NET GridView