Datagrid changing column headings

[1todd1]

There must be an easyer way to change the column headings of a datagrid control than going through the columns collection

Has anyone any ideas please )

Dim f As Column

For Each f In DataGridPeople.Columns
Select Case f.Caption
Case "FirstName"
f.Caption = "First Name"
Case "LastName"
f.Caption = "Last Name"
end select
next i


Thanks for your thoughts and comments

Todd

 

[CCLINT]

Because a datagrid, as opposed to say a FlexGrid, is actually a collection of columns, you need to set each column header seperately. Once set, you can prevent the column header names from reverting back to the field names during a requery by using the HoldFields and Rebind methods.
You could also set the grid header to the field's Description property (Set in the database) using the DDL from ADOX.

Or, you could create an array of caption text for each grid, and loop through each column and using the column index to match up with the array index.