c# - How to dynamically make columns of jQuery DataTable disappear -


here information development environment:

  • microsoft visual studio professional 2013

  • .net framework 4.0

  • jquery-2.1.4.min.js

  • jquery datatables 1.10.7

  • newtonsoft.json.7.0.1

  • jquery ui 1.11.2

  var getauserslogs = function (sortcolumn, isdescending) {             $('#personaluserslogtable').datatable({                 "aocolumns": [                             { "stitle": "logbsonvalueid" },                             { "stitle": "userid" },                             { "stitle": "driver name" },                             { "stitle": "log date" },                             { "stitle": "duty cycle" },                             {                                 "mdata": null,                                 "mrender": function (obj) {                                     return '<a href="#" id="' + obj.dt_rowid + '" onclick="viewlogaudithistory(this)"  >log hist</a>';                                 }                             },                             {                                 "stitle": "details",                                 "mdata": null,                                 "mrender": function (obj) {                                     return '<a href="#" id="' + obj.dt_rowid + '" onclick="viewparticularlogsinfo(this)"  >view</a>';                                 }                             }             ],             "aocolumndefs": [{ "bvisible": false, "atargets": [0, 1, 5] }],             "idisplaylength": 5,             "sdom": '<"clear">frtip',             "bprocessing": true,             "bserverside": true,             "blengthchange": false,             "bpaginate": true,             "bdestroy": true,             "bsort": false,             "binfo": true,             "bfilter": false,             "sajaxsource": 'logslist.aspx/bindpersonaluserslogdatatable',             "bjqueryui": true,             "bdeferrender": true,             "spaginationtype": "full_numbers",             "fnserverparams": function (aodata) {                 aodata.push(                             { "name": "sortcolumn", "value": sortcolumn },                             { "name": "isdescending", "value": isdescending }                 );             },             "fnserverdata": function (ssource, aodata, fncallback) {                 $.ajax({                      "datatype": 'json',                     "contenttype": "application/json; charset=utf-8",                     "type": "get",                     "url": ssource,                     "data": aodata,                     "success":                             function (msg) {                                 var json = jquery.parsejson(msg.d);                                 fncallback(json);                              },                      beforesend: function () {                         $('.loader').show()                     },                     complete: function () {                         $('.loader').hide()                      }                 });             }         }); // end of personaluserslogtable datatable method     }     // end of code used bind data table 

the invocation bindpersonaluserslogdatatable method in c# file. within bindpersonaluserslogdatatable, code determine if logged in user admin or plain user.

if logged in user plain user, want dynamically make of columns in jquery datatable invisible.

could please tell me changes need make in order aforementioned code desired functionality?

you can use column().visible() or columns().visible() api methods dynamically show/hide single column or set of columns.

"success": function (msg) {    var api = $('#personaluserslogtable').datatable();     var json = jquery.parsejson(msg.d);     // enable/disable columns based on user type                if(json.isadminuser){       api.columns([2,3]).visible(true);    } else {       api.columns([2,3]).visible(false);    }     fncallback(json); }, 

Comments

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

jquery - Clone last and append item to closest class -

c - Unrecognised emulation mode: elf_i386 on MinGW32 -