Paginatiion not working in FixedColumns example - server-side processing..plz help!!

Paginatiion not working in FixedColumns example - server-side processing..plz help!!

suvro84suvro84 Posts: 6Questions: 0Answers: 0
edited September 2013 in General
With Refernce to
http://datatables.net/release-datatables/extras/FixedColumns/server-side-processing.html
i tried for very large data 5000 records but the grid is becoming blank...with no records coming..Plz help!!
my script is

$(document).ready(function () {
var oTable = $('#grid').dataTable({
"sScrollY": "300px",
"sScrollX": "100%",
"sScrollXInner": "150%",
"bScrollCollapse": true,
"bServerSide": true,
'bPaginate': true,
"sAjaxSource": 'Home/GetAjaxData',
'sPaginationType': 'full_numbers',
'iDisplayLength': 5,
"aoColumns": [

{ "mData": "ID" },
{ "mData": "Name" },
{ "mData": "Address" },
{ "mData": "Town" }
]

, "fnInitComplete": function () {
new FixedColumns(oTable, {
"iLeftColumns": 2,
"iLeftWidth": 350
});
}

});

});


if i uncomment the fix width portion, data is coming in grid ..and pagination is also working properly..





$(document).ready(function () {
var oTable = $('#grid').dataTable({
// "sScrollY": "300px",
// "sScrollX": "100%",
// "sScrollXInner": "150%",
// "bScrollCollapse": true,
// "bServerSide": true,
'bPaginate': true,
"sAjaxSource": 'Home/GetAjaxData',
'sPaginationType': 'full_numbers',
'iDisplayLength': 5,
"aoColumns": [

{ "mData": "ID" },
{ "mData": "Name" },
{ "mData": "Address" },
{ "mData": "Town" }
]

// , "fnInitComplete": function () {
// new FixedColumns(oTable, {
// "iLeftColumns": 2,
// "iLeftWidth": 350
// });
// }

});

});
This discussion has been closed.