[CLOSED] Add Columns to GridPanel. Server side

[Antonio09]

I add columns to a gridpanel in server side:

doc.Load(Server.MapPath("Puestos.xml"))
        Dim contador As Integer = 0
        Dim ID As String = "", Texto As String = ""
            For Each nodoCampo As XmlNode In nodo.SelectNodes("control")
                    ID = nodoCampo.Attributes("id").Value
                    Texto = nodoCampo.Attributes("label").Value
                    Dim field As New ModelField("col" & ID, ModelFieldType.String)
                    StoreMatchSol.AddField(field, contador + 10)
                    StoreMatchSol.Model(0).Fields.Insert(contador + 10, field)

                    Dim col As New Column
                    col.ID = "col" & ID
                    col.Text = Texto
                    col.Width = "100"
                    col.AutoHeight = True
                    col.DataIndex = "col" & ID
                    col.Align = Alignment.Center

                    GridPanelMatch.AddColumn(col)

                    contador += 1
            Next

When I add a few columns the page loads fast but I need to add like 70 columns to the grid and if I do it the page takes more than a minute to load, is there a way of make it faster??

[Vladimir]

How many records do you load to the store?

[Vladimir]

When you call posted code? During ajax request or inital page load?
If during initial page load then you have to use

grid.ColumnModel.Columns.Add(...);

instead

grid.AddColumn(...);

AddColumn must be used during ajax request only (dynamic column adding to rendered grid)

[Antonio09]

I'm not loading records yet, because just adding columns it's too slow.

I call posted code during ajax request when the gridpanel is already rendered.

Should I build the entire grid in code behind so I can use grid.ColumnModel.Columns.Add(...); ?? Is it faster to load?

[Vladimir]

try to pass false as second argument (prevent update layout) for all columns except last, for last column pass true

GridPanelMatch.AddColumn(col, false)

[Antonio09]

I tried it and it's still loading slow.

Now I'm proving with

grid.ColumnModel.Columns.Add(...)

And it loads fast! But I have to use

Panel.UpdateContent()

Panel is the container of my grid, but updatecontent fires an error when I put the Locked property in one of the static columns:

<ext:Column ID="C1" runat ="server" Resizable="false" header="Nombre" DataIndex="Nombre" Width ="170" Locked="true" />

The error message is: "Can not get property value 'un': object is null or undefined"

Why is this happening?

[Antonio09]

Is there an alternative to solve this?

[Vladimir]

Alternative is rerender GridPanel (in this case, do not use AddColumn/AddField, add columns and field directly to own collections)

GridPanel1.Render();