Autogenerate columns and modify

[Patrick Barranis]

Hi.  I'm using the latest version of the MVC controls on MVC3.  Is it possible to autogenerate the columns but then make modifications?  I only want to hide one column, so it's much faster to autogenerate and then modify rather than write the column bindings from scratch.

If the answer is no, can you please speculate on when you might add a feature to allow it?  I've noticed a number of other forum posts asked about doing something similar.

Thanks!

[Rosen]

Hi Patrick Barranis,

Indeed you can modify setting of the autogenerated columns by supplying a callback to the AutoGenerate method:

<%= Html.Telerik().Grid(Model)
        .Name("Grid")
        .Columns(columns =>
                {
                    columns.AutoGenerate(column =>
                        {
                            column.Width = "150px";
                            if (column.Member == "CustomerID")
                                column.Visible = false;
                        });
                })
%>

Please refer to this online demo for more details.

Regards,
Rosen
the Telerik team

[Patrick Barranis]

Oh, thanks.  I was looking at that overload but I couldn't figure out what it could be used for.  That explains it - thanks!

[Patrick Barranis]

Hi Atanas,

Is it possible to hide a column by this method?  I have the following code in the view:

@(Html.Telerik().Grid<SystemDataViewModel>()
    .Name("SystemData")
    .PrefixUrlParameters(false)
    .Columns(c =>
        c.AutoGenerate(a => { if (a.Member == "ID") a.Hidden = false; }) )
    .DataBinding(b => b.Ajax().Select("UpdateIndexGrid", "SystemData",
        ((QuickFilterModel)ViewBag.QuickFilterModel).GetRouteValues()))
    .HtmlAttributes(new { Class = "NonAjaxSelectionGrid QuickFilterGrid" })
    .Reorderable(r => r.Columns(true))
    .Resizable(r => r.Columns(true))
    .Selectable()
    .Sortable()
    .Pageable(p => p.Style(GridPagerStyles.NextPreviousAndNumeric | GridPagerStyles.PageInput | GridPagerStyles.Status)))

What I get in Chrome is a missing column header with the cell still visible.  In IE the cell is hidden but two column headings are gone ("ID" and the next column after that too).

Is this possible or do I need to "hack it" by putting in cell attributes to hide the cells and whatnot?

Thanks in advance.

[Patrick Barranis]

Hopefully just one last additional question: is there any way to control the order of autogenerated columns?  I tried using the Order property of the DisplayAttribute, and I also tried the Order property of the ColumnAttribute.  Neither seemed to have any effect, even when I specified it on every property in the class.

Thanks.

[Rosen]

Hello Patrick Barranis,

I'm afraid that currently there is no way to specify the order in which autogenerated columns will be created.

All the best,
Rosen
the Telerik team

[Simon]

Hello Rosen,

is is still not possible to specify the order in which autogenerated columns will be created? How is Telerik Grid ordering autogenerated columns anyway?

Thanks for help!

Simon