how to access only those no of records which displayed in table on single page using datatable.

katdare01

As I'm fetching thousands of record from database asp.net grid view is very slow in binding data.
Is there any method to fetch only 10 or 50 ... records that displayed by datatable at one time.

jLinux

You mean you want to know how to query the database only for a certain amount of rows?

If so, I asked @allan the same thing, he said that the Deferred Loading was the best bet.

But you can also try the "Pipelining data to reduce Ajax calls for paging" example

Sources:

• https://www.datatables.net/examples/server_side/index.html
• https://www.datatables.net/examples/ajax/index.html

katdare01

Thank you @jLinux for reply...
It seems that this is the answer what I was expecting...
Let I'll go through the links