jquery datatable plugin has already inbuild paging functionality.

So will you please let me know what exactly you want to achieve ?

If you want server side processing refer below link.

Populate ASP.Net GridView using jQuery DataTable plugin with Server Side data

If you want to paging using sql refer below article.

Client Side AJAX based Paging using jQuery in ASP.Net GridView