I am using ASP.NET MVC and initially the HTML table data is loaded from the server (loop data using razor).
In document.Ready() I am applying jQuery datatable on the HTML table.
All data is returned from the server. I just need to show it 10 rows every page scroll.
How to make the datatable load more data on page scroll?
var table = $('#reports_total_spend_table').DataTable({
           "order": [[1, 'asc']],
           paging: false,
           searching: false,
           info: false,
           fixedHeader: true,
           scrollY: "450px",
           scrollX: true,
           scrollCollapse: true
       });
 
    