Search

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

Hii If i am in page 2 and need to reload grid with some action then how can i come to current page after reload data tables in data tables

First off, I would like to say thanks to anyone everyone who has contributed to the DataTables plug in. It gets my vote hands down as the best and most useful jQuery plug in. Now my question. I have a table that has 500 records. When grouped, it has 5 groups, each with 100 record. If I set it to page on 50 records per page, I get the first 50 records of the 1st group. What I think I would get is the first 50 groups, or in this case, all 5 groups. Example: http://jsfiddle.net/WOPiersol/33fD6/1/ Can this be configured? Thanks, WOPiersol

How do automatic pagination, need to change the page of my tables automatically, without manual interference. My Souce... $(document).ready(function() { var oTable = $('#tbleitos').dataTable( { "bPaginate": false, "bLengthChange": false, "bFilter": false, //classificação de colunas "bSort": false, "bInfo": false, //largura inteligente "bAutoWidth": false, //envio de mensagens do Display "oLanguage": { "sProcessing": "Aguarde enquanto os dados são carregados …", "sLengthMenu": "Mostrar _MENU_ registros por pagina", "sZeroRecords": " - NÃO HÁ REGISTRO DISPONÍVEL PARA A DATA ATUAL - ", }, //configuração das colunas "aoColumns" : [ { "sWidth": "10px"}, null, null, null, null, null, null, null, null, null, null, null], "bProcessing": false, "bServerSide": true, //Aatualização em real-time "sAjaxSource": "consulta_cirurgias.php?sEcho=0" } ); setInterval(function() { //oTable.fnReloadAjax("consulta_cirurgias.php?sEcho=1"); oTable.fnDraw(); //dataTable.fnCreatedRow("consulta_cirurgias.phpsEcho=1"); //$('table.dataTable td').css('font-size', 70); },3000); //3 segundos } );