Which Data Table Should i use

SandeepM

I have 1,72,650 records in one of my table and i want to display all records.
I have used server side pagination with ajax call
$(document).ready(function() {
var oTable7 = $('#example').dataTable({
"bJQueryUI": true,
"bAutoWidth": true,
"bLengthChange": true,
"sDom": 'T<"clear">lfrtip',
"bProcessing": true,
"bServerSide": true,
"sPaginationType": "full_numbers",

"sAjaxSource": "/EF/reports/test/form/firstjsp.jsp",
"aoColumns": [
{ "mDataProp": "AssetID" },
{ "mDataProp": "LocationID" },
{ "mDataProp": "Uploadedby" },
{ "mDataProp": "MobileNo" },
{ "mDataProp": "Uploaddate" },
{ "mDataProp": "PCName" },
{ "mDataProp": "UserName" },
{ "mDataProp": "RAM" },
{ "mDataProp": "Domain" },
{ "mDataProp": "CPU" },
{ "mDataProp": "NoofCPU" },
{ "mDataProp": "CPUID" },
{ "mDataProp": "CPUCaption" },
{ "mDataProp": "L2Cache" },
{ "mDataProp": "Speed" },
{ "mDataProp": "OperatingSystem" },
{ "mDataProp": "OSversion" },
{ "mDataProp": "OSBuild" },
{ "mDataProp": "Installationdate" },
{ "mDataProp": "Manufacturer" },
{ "mDataProp": "Installedon" },
{ "mDataProp": "Location" },
{ "mDataProp": "Antivirus" },
{ "mDataProp": "MACAddress" },
{ "mDataProp": "LANCard" },
{ "mDataProp": "Resolution" },
{ "mDataProp": "Monitor" },
{ "mDataProp": "HDDModel" },
{ "mDataProp": "Type" },
{ "mDataProp": "Size" },
{ "mDataProp": "CDrivesize" },
{ "mDataProp": "WANIP" },
{ "mDataProp": "Server" },
{ "mDataProp": "Productid" },
{ "mDataProp": "MUID" },
{ "mDataProp": "MMID" }
]
} );
} );

but while fetching the records I must need to put LIMIT in query else it's giving an error java.lang.ArrayIndexOutOfBoundsException: -1

allan

I don't really know Java so I won't be able to help much, but have a look at this example script to see one possible way it can be done with server-sid processing and JSP: http://datatables.net/development/server-side/jsp . For JSP help, I'd suggest posting in a JSP forum.

Allan

anony

is there such a way for .ascx too?

tnx

allan

For a what? :-)

Any server can be used with server-side processing in DataTables - the DataTables library is completely independent from the server. See this page for more information: http://datatables.net/usage/server-side

Allan

SandeepM

thanks