What is the best way to delete a grid that is dynamically created at run time?

first i have a grid with only 2 columns at design time...i bring back data to a dataview which will have 1 or more new(add) columns - that code i got working with no problems -

however i get different data with different selections and i find the grid remembers the last columns from the previous run time build (does that make sense?)

so i wanted to put in a cleanup routine that will remove all the columns (except the ones i created at design time) before i rebuild - what is the best way to do that?

Here is my dynamic build:

'inDV is my dataview

Dim isFound As Boolean
For Each vCol In InDV.Table.Columns
For Each gCol In MyGrid.Columns
If gCol.DataField = vCol.ColumnName Then
isFound = True
End If
Next
If Not isFound Then
Dim nCol As New EO.Web.StaticColumn
nCol.DataField = vCol.ColumnName
nCol.HeaderText = vCol.ColumnName
nCol.Width = (vCol.ColumnName.Length * 7) + 3 '8 pixels a charachter
MyGrid.Columns.Add(nCol)

Else
isFound = False
End If
Next

Here is what i would like to do (but i am having difficulties with catch 22)

'remove all columns except the one named "Host" and "Delete" (built at design time)"
Dim gCol As EO.Web.GridColumn
Dim vCol As DataColumn

'clean up old colums first
Dim cCount As Integer = MyGrid.Columns.Count
Dim i As Integer
For i = 0 To cCount - 1
If i <= MyGrid.Columns.Count Then 'if count keeps changing how does this work?
gCol = MyGrid.Columns(i)
If MyGrid.Columns(i).Name = "Host" Or MyGrid.Columns(i).Name = "Delete" Then
'skip
Else
If gCol.DataField <> "" Then
MyGrid.Columns.Remove(gCol) '
End If
End If
End If
Next

anyway i guess i am trying to emulate the old ms grid which dynamically builds the grid based on the columns in the datasource -

Hi,

Thanks for the update. That is the correct way to do it. We also have a new version that added a new Visible property on each GridColumn, so that you will be able to hide it instead of removing it. Please let us know if you would like to have that version.

Thanks!

Hi,

I believe the version on the download page already have this feature.

Thanks!

Hi,

See here on how to find out the version you are running:

http://www.essentialobjects.com/forum/postst2942_How-to-find-out-EOWeb-Controls-build-number.aspx

The version of the current build is always displayed on the download page.

Thanks