Search
5738 results 401-410
Forum
- 10th Jun 2016REG : remove paging save when StateSave = trueHi 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 ?
- 30th Apr 2016How to set the number of pages in the "numbers" paging type?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;
- 3rd Nov 2015Remove rows when paging is enabledI'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?
- 16th Oct 2015Filtering and Paging with ASP Classic problems.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...
- 15th Sep 2015sorting, paging, search box not seenhi, 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.
- 7th Sep 2015How to implement Virtualized Scrolling with server side paging ?Wanted to track the page change event while scrolling
- 13th Jul 2015paging server side does not worki 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
- 4th May 2015Custom paging with array of JavaScript objectsI 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
- 22nd Apr 2015How Do i Get a checkbox value in datatable while using PagingI 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); } } });
- 21st Apr 2015DataTable filtering and pagingcolumnDefs":[{"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