Search

can I restrict which columns are editable in the

table with search, pagination, columns and bubble editing and

lengthChange: false, ajax: "/api/Student", columns: [{ data: "Name" }] }); var tableTools

autowidth: "false", ajax: "lib/getAppointments.php?id="+GetURLParameter("id")+"&uid="+uid+"&t=c", columns: [ {data: "Appointments.AppointmentDate"}, {data: "StatusOptions.Status",

example column with checkboxes: "columns" : [ { "data" : row[0], "render" : function(data , type , row){ return '<input class="ch" type="checkbox" value='+data+' />' } } ], and script which counts selected checkboxes $(document).ready(function (){ $('body').on('change' , '.ch' , function(){ var checked = 0 $('.ch:checked').each(function (){ checked = checked +1 console.log(checked) $('.info').text(checked + " rows are selected") }) }) })

For example: "columns": [ { "class" : "class001", // or "className" : "class001" - the same result "data" : 'name', }, { "data" : "score" }, ], other way: yourDataTable.on( 'draw', function () { $('tr td:nth-child(6)').each(function (){ $(this).addClass('class001') }) }); But first way is simpler

amp;en=" + extname, // ajax source, "columns": [ { "data": "shp_payment_options.sort_order" , className: "center"

You have to define columns. Do not use wildcards. try "Select column1, column2, column3 from table1"

searchable false for all columns. But still somehow the

the available values in columns and want to multi-select