Gridview paging not display while i use Fetch Next in sql query.

when i use in sql query like

ALTER PROCEDURE TestPaging
(
@PageNumber INT
,@PageSize INT
)
AS
DECLARE @OffsetCount INT
SET @OffsetCount = (@PageNumber-1)*@PageSize
SELECT *
FROM [Employee]
ORDER BY [Id]
OFFSET @OffsetCount ROWS
FETCH NEXT @PageSize ROWS ONLY

query working but gridview default property allowpaging and pagesize doesnot working while i use FETCH NEXT.