I need to implement custom paging and sorting functionalities in React JS using web api and SQL Server.
On click of header column or on click of paging link, I have to make a web api to get the relevant SQL procedure and bind the table accordingly.
The first api call will fetch only 10 records from DB. So, on click of any column header, server side call needs to be made and sort whole dataset in the backend and then retrieve the first 10 records after sorting.
Please provide your suggestions.