How to hide columns after binding data

[Pavel]

Hi,

I have a gridview with datasource defined and I just want only some of the columns to be visible. But when I bind data using DataSource property, my design time column visibility settings are lost and all columns are shown.

I'm using Q2 2009 trial version, but in Q1 everything works fine...

Thanks for solution.

PK

[Joel Kraft]

I filed the same issue (in the Q1 service pack) as a bug report, you have to set the AutoGenerateColumns on the GridViewTemplate to false. Below is a chunk from my extender class that adds a SuppressAutoGenerateColumns function to both the RadGridView and GridViewTemplate and recurses through any child GridViewTemplates. Call it once on the grid and it will behave as before.

    public static class RadGridViewExtender
    {
        public static void SuppressAutoGenerateColumns(this RadGridView gridView)
        {
            SuppressAutoGenerateColumns(gridView.MasterGridViewTemplate);
        }

        public static void SuppressAutoGenerateColumns(this GridViewTemplate gridViewTemplate)
        {
            gridViewTemplate.AutoGenerateColumns = false;
            foreach (GridViewTemplate t in gridViewTemplate.ChildGridViewTemplates)
            {
                SuppressAutoGenerateColumns(t);
            }
        }
    }

[Pavel]

Problem solved... Thanks!

[Julian Benkov]

Hello Pavel,

In the previous version of RadGridView we used to make checks whether the new DataSource object properties are the same like the previous data source properties and in this situation we only loaded the new data. This approach created some inconsistent states in RadGridView, problems with rebuilding the internal data, and performance issues as well.

In the new version when a new DataSource is used, RadGridView makes clean rebind operation. In your scenario where the DataSource is frequently changed, you can set AutoGenerateColumns property of MasterGridViewTemplate to false and all your columns settings will be kept correctly.

public GridForm()
{
    InitializeComponent();

    this.radGridView1.MasterGridViewTemplate.AutoGenerateColumns = false;
}

Thank you for your answer Joel.

Best wishes,
Julian Benkov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.