[Solved] how to get columns that has been hidden?

[Zhaoning]

i want to know how many columns has been hidden for next load same view with grid.

i can use the ColumnContextMenu method to visible or hide a column, but how can i get all columns has been hidden?

i want to use client event ,but i can not find. which event can be use for me ?

whether has other way to solve my problem?

[Dadv]

Hi,

You could use this in javascript to add the fields names to the query :

<script type="text/javascript">

function Grid_onDataBinding(e) {
var hiddens= '';
 $('.t-header:hidden').each(function (index) { hiddens += $(this).text() + ',' });
 
    // pass additional values by setting the "data" field of the event argument
    e.data = {
         hiddens: hiddens 
    };
}
</script>

I didn't test it but i think something like this will work.

Regards,

[Zhaoning]

thks Dadv!

but i can't get anything.

the grid is telerik UI Component for ASP.NET MVC.

the source code of web page is :

jQuery(document).ready(function(){
jQuery('#Menu').tMenu();
jQuery('#ELISAAssay').tGrid({columns:[{"title":"Name","member":"Name","type":"String"},{"title":"Instrument Assay Name","member":"InstrumentAssayName","type":"String"},{"title":"Kit Lot","member":"KitGUID","type":"Object"},{"title":"Revision Number","member":"RevisionNumber","type":"Number"},{"title":"Created By","member":"CreatedBy","type":"Object"},{"title":"Description","member":"Discription","type":"String"},{"title":"Action Link"}], plugins:["filtering","resizing","reordering"], urlFormat:'/AusLIMS.Web/Assay/ELISAQualitative?ELISAAssay-page=%7B0%7D&ELISAAssay-orderBy=%7B1%7D&ELISAAssay-filter=%7B3%7D', total:0, currentPage:1, pageSizesInDropDown:["5","10","20","50"], pageOnScroll:false, sortMode:'single', columnContextMenu:true, 

[Nikolay Rusev]

Hello Zhaoning,

There isn't event to indicate that particular column is hidden/shown. However in the moment you need to get which columns are hidden you do so by using the following code.

var grid = $("#ELISAAssay").data("tGrid");
var hidden = $.grep(grid.columns, function(column) { return column.hidden });
//and if you need the fields to which the column is bound to

hidden = $.map(hidden, function(column) { return column.member });

Regards,
Nikolay Rusev
the Telerik team

[Zhaoning]

thks Nikolay Rusev, i have get them !

why  no event  could be used after options window show or hide column hide ?

[Nikolay Rusev]

Hello Zhaoning,

Until now there was no requests for such event and this is the reason for not having it. We will think about introducing such event i future versions of the Grid. For the moment you can use the suggested implementation.

All the best,
Nikolay Rusev
the Telerik team

[Rajeev]

Hi Nikolay Rusev ,
I want to hide grid column on client. I am using this code in java script. 

$('#CheckboxID').click(function () {
 var grid = $("").data('tGrid');
if ($(this).is(':checked')) {
// the checkbox was checked
grid.showColumn("ColumnName");

} else {
// the checkbox was unchecked
grid.hideColumn("ColumnName");
}
});

But I got this error.
Microsoft JScript runtime error: Object doesn't support property or method 'showColumn'

Thanks
RK