Paginatiion not working in FixedColumns example - server-side processing..plz help!!
Paginatiion not working in FixedColumns example - server-side processing..plz help!!
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
// });
// }
});
});
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.