Search

Hi Allan, I want only save "Records per page" in my localstorage and all the information of datatable is saving like sorting, paging(ie page :2).. How can I implement that on Records per page is save ?

Currently, I am setting the last page using below. However, its not being set. dataTableapplicant').on('page.dt', function () { var info = $rootScope.applicantTable.page.info(); info.pages = $rootScope.noOfPages;

I'm facing an issue. I have the ability to delete row based on a class name. ie: table.rows($('.' + trackingId)).remove().draw(false); My problem is that the pagination is enabled and in this case, only the row with corresponding TrackingId of the current page are removed. Any idee how to solve that?

I've started to work out a server side script. My some problems solved this link. But my datatable does not work correctly. Maybe my problem is simple but I didn't solve this. My last script codes: $(document).ready(function() { $('#example').DataTable( { processing: true, serverSide: true, "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "Hepsi"]], pagination:true, "sPaginationType": "full_numbers", ajax: "musteri_list_load.asp" } ); } ); And my musteri_list_load.asp codes: <% sEcho = Cint(Request("sEcho")) iDisplayLength = Cint(Request("iDisplayLength")) iDisplayStart = Cint(Request("iDisplayStart")) sSearch=request.QueryString("sSearch") %> <% set rs1=Server.CreateObject("ADODB.recordset") rs1.Open "Select * from ajax", bag,1,3 iTotalRecords = rs1.RecordCount set rs=Server.CreateObject("ADODB.recordset") rs.Open "Select * from ajax WHERE engine like '%" & sSearch & "%' ORDER BY id ASC", bag,1,3 iTotalDisplayRecords = rs.RecordCount output = "{""draw"": 1, ""recordsTotal"": "& iTotalRecords &", ""recordsFiltered"": "& iTotalDisplayRecords &", ""data"":[" i = 0 if rs.eof = false then rs.move(iDisplayStart) do while i < iDisplayLength and not rs.eof output = output & "[" & """"& rs("ID") & """,""" & rs("engine") & """]," rs.movenext i=i+1 loop 'here we eliminate the last comma in the aaData output=Left(output,Len(output)-1) output = output & "]}" End If response.write output I don't know how to pass iDisplayLength, iDisplayStart and sSearch parameters to my asp page. If I change iDisplayLength and iDisplayStart value to integer in my asp page, my datatable's first page is works. But pagination and filter are not working. It show "Processing..." text and it does not anything. If it like the above, it shows error code. I don't know where the errors. Please help me. Thanks...

hi, I'm using https://cdn.datatables.net/1.10.9/js/jquery-1.11.3.min.js and https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js files in my code with tag and css file with tag. But its not showing sorting/paging/search box on my grid. Its only displaying data in table.

Wanted to track the page change event while scrolling

i have: in js: $('#gridResults').dataTable({ "processing": true, "serverSide": true, "scrollY": "300px", "scrollCollapse": true, "bDestroy": true, "sPaginationType": "full_numbers", "ajax": { 'type': 'GET', 'url': urlBase + "api/SystemUser/GetList", 'pages': 10, 'data': request }, "aoColumns": [ { "sTitle": "SystemUserID", "mData": "SystemUserID", "bSearchable": false, "bSortable": false }, { "sTitle": "Full Name", "mData": "FullName", "bSearchable": false, "bSortable": true }, { "sTitle": "Login Name", "mData": "LoginName", "bSearchable": false, "bSortable": true }, { "sTitle": "Email", "mData": "Email", "bSearchable": false, "bSortable": true } ], "columnDefs": [ { "targets": 0, "visible": false, "searchable": false } ] }); in my web api [HttpGet] public dynamic GetList([FromUri] BEUserSearchRequest request) { BLSystemUser oBL = new BLSystemUser(); List oList = new List(); oList = oBL.GetList(request.SystemUser, request.PaginAttributes.PageNumber, request.PaginAttributes.PageSize); var model = new { sEcho = request.PaginAttributes.PageNumber, iTotalRecords = oList.Count(), iTotalDisplayRecords = oList.Count(), aaData = oList }; return model; } Please, I need help Thanks

I am working on a application which is nicely modularized using requirejs. One of the modules called data service is in charge of providing other modules with data. Pretty much all get* methods of this module return javascript script objects in the the following format: res = { totalRows: 537, pageSize: 10, page: 15, rows: [ { id: 1, name: 'John' ... }, { id: 2, name: 'Michael' ... }, { id: 3, name: 'Stephen' ... }, { id: 4, name: 'Dan' ... }, { id: 5, name: 'Rob' ... }, .... ] } Is it possible to initialize the data table so that it "knows" that we are currently viewing page #15 of total 54 pages and that consequently it builds the pager correctly to allow the user to view other pages. Thanks in advance! Zen

I have Created a datatable with first column as checkbox for each row and i was doing a ajax call while on successing i was trying to check the checkbox but it was checking for only first page. not for other pages. below is my code, please help me in that. $.ajax({ type: 'GET', url: '/PriceList/GetCheckedAccount/', data: { get_param: data1 }, dataType: 'json', success: function (response) { //alert("success"); for (var i = 0, len = response.aaData.length; i < len; i++) { var id = response.aaData[i][1]; var chk = $(".chkBox" + id); chk.attr("checked", true); } } });

columnDefs":[{"orderable":false, "targets":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]}], "searching":false, "sorting":[[8,"desc"]], "paging":false, "filtering":false, "autoWidth":false, "info":false, "destroy":true