我在此链接中使用数据表来显示网格。https://datatables.net/examples/basic_init/hidden_columns.html
我使用 (columnDefs.targets) 显示几个默认列,然后我添加了从此链接显示和隐藏该列的功能:
https://datatables.net/examples/api/show_hide.html
首先,我加载的页面是正确的并显示默认列,当我尝试显示/隐藏时,它显示所有列而不是默认列,我不确定如何仅显示默认列。
这是我的代码:
$(document).ready(function () {
var table = $('#DataLegal').DataTable({
"columnDefs": [
{
"targets": [ 4,5,6,7,8,9,10,14,15,16,17,18,19,20,21,22,23,24,25,26,27],
"visible": false
// "searchable": false
}
]
} );
//This is show/Hide part
var ms = $('#magicsuggest').magicSuggest({
// Converts our C# object in a JSON string.
data: @Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(columns))
});
$(ms).on('selectionchange', function(e,m){
// Turn on columns
$.each(table.columns()[0], function(index) {
table.column(index).visible(true);
//here how I can only turned on the DefColumns?
});
// Turn off each column in the value array... Value = int[0,1, 2, ...]
$.each(this.getValue(), function(index, item) {
table.column(item).visible(false);
});
});
});