Show only specific amount of rows in table and rest export as Excel

armashansari

I'm having Web Service which gets data from DB. And then that DataSet is converting into JSON.
Using AJAX I'm getting JSON data.

The problem is browser not responding on huge amount of data. And DataTable take so much time to load.
So for that, I want to show x number of rows in DataTable and rest Export as Excel.
Where x can be changed.

kthorngren

The problem is browser not responding on huge amount of data. And DataTable take so much time to load.

Start with this FAQ.

So for that, I want to show x number of rows in DataTable and rest Export as Excel.
Where x can be changed.

If you use server side processing as described in the previous FAQ link then see this FAQ regarding exporting server side datatables.

Kevin