Search

Hi Friends, I am developing an application in MVC ASP.Net. I have used Datatables inmy application. I have used model binding for the datatable as follows Script for Datatable $('#tblReports').DataTable({ paging: true, lengthChange: false, searching: false, ordering: true, info: true, autoWidth: true, scrollX: true, dom: 'Bfrtip', buttons: [ 'excel' ] }); HTML table Employee Name Leave Type From Date To Date No of Days Is Half Day Leave Description Status Approved By Approved Date Rejected By Rejected Date Supervisor Comments foreach (var leaveDetail in Model) { if (leaveDetail.LeaveStatusName != "Save" & leaveDetail.LeaveStatusName != "Cancel") { leaveDetail.EmployeeName leaveDetail.LeaveTypeName leaveDetail.FromDate.ToShortDateString() leaveDetail.ToDate.ToShortDateString() if (leaveDetail.HalfDay != null) { if (leaveDetail.ToDate.ToShortDateString() == leaveDetail.FromDate.ToShortDateString()) { ("1"); } else { ((leaveDetail.ToDate - leaveDetail.FromDate).TotalDays); } } else { ("0"); } leaveDetail.HalfDay leaveDetail.EmployeeComments leaveDetail.LeaveStatusName leaveDetail.ApprovedBy leaveDetail.ApprovedDate leaveDetail.RejectedBy leaveDetail.RejectedDate leaveDetail.SupervisorComments } } Now I need to load only the Datatable with out refreshing the page. I am loading the all the views in one master view. Could you help me.

Hi, I would like to add refresh button to my datatable but I have a problem with the position of the button. I have tried with Custom toolbar elements and with Buttons extension and I have the same problem. This is part of my code acquisitionTable = $('#acquisitionsTable').DataTable({ responsive: true, "bLengthChange": false, deferRender: true, scrollY: '70vh', scrollCollapse: true, scroller: true, dom: 'Bfrtip', buttons: [ { text: 'Refresh<i class="fa fa-refresh"></i>', action: function ( e, dt, node, config ) { alert( 'Button activated' ); } } ], I have attached the image. In browser debug I see: <div class="dt-buttons"> <a class="dt-button" tabindex="0" aria-controls="acquisitionsTable" href="#"> <span>Refresh<i class="fa fa-refresh"></i></span> </a> </div> <div id="acquisitionsTable_filter" class="dataTables_filter"> <label>Search:<input type="search" class="form-control input-sm" placeholder="" aria-controls="acquisitionsTable"> Do you know what is wrong? The buttons css exist but it doesnt load for the specific element.Thanks

1 Tiger Nixon System Architect Edinburgh 61 $320,800 2 Garrett Winters Accountant Tokyo 63 $170,750 3 Ashton Cox Junior Technical Author San Francisco 66 $86,000 4 Cedric Kelly Senior Javascript Developer Edinburgh 22 $433,060 5 Airi Satou Accountant Tokyo 33 $162,700 6 Brielle Williamson Integration Specialist New York 61 $372,000

I am using data tables to display a table with more than 5000 records along with that i will have to hide/show rows based on checkbox inputs. ex. I have 3 checkboxes named "A, B and C". When I click 'A' i have to display only records that contains 'Aaaa' in a particular column data of that row. When I loop through the table and hide/show it takes lot of time to render and sometimes the script breaks. Any suggestions and help would be great.

plz help me..

I've linked both .js file and .css file in my code as below ,but it shows the grid with my data but its not showing pagination/filter/sorting.. Am using a visual webpart and below is my code for ascx file <script type="text/javascript"> $(document).ready(function () { $('#GridView1').dataTable({ "sPaginationType": "full_numbers", "aaSorting": [], "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]], "pageLength": 14, //"scrollY": "200px", //"scrollCollapse": true, "sDom": 'T<"clear">lfrtip', "tableTools": { "sSwfPath": "http://www.datatables.net/release-datatables/extensions/TableTools/swf/copy_csv_xls_pdf.swf" }, /* Disable initial sort */ "bDestroy": true, "bProcessing": true, "bpaging": false, "bSort": false }); }); </script> Please help

I have columns on a datatable that are from a product table and other columns from an attribute_values table. The attributes table is related to the attribute_values table via the foreign key attribute_id. The attributes table which hold the name of each unique attribute. The attributes table is flexible, allowing a variable number of attributes to be stored from a variety of different other models using attributable_id and attributable_type fields. How do I make these fields searchable over AJAX using DT with yajra/laravel-datatables? For instance, I might have attributable_id=1 AND attributable_type='Product' AND attribute_id=5.

I am using jquery.dataTables but i am not able to how to use it can any one post it with code or example.

Hi Everybody, after changing the datatable to work with server side processing the input text box stop working there's not mention that the input text box not working in server side mode. how can i get it to work? thank you

ajax data source code $(document).ready(function() { $('#example').DataTable( { "ajax": "data/objects.txt", "columns": [ { "data": "name" }, { "data": "position" }, { "data": "office" }, { "data": "extn" }, { "data": "start_date" }, { "data": "salary" } ] } ); } );