How do I change the columnheader(s) in a Datatable ?

[paulv]

How can I change the header of a DataTable column (DTParameter) during runtime ?
I can add a column (DTSheet.AddParameter), get the name of a certain column (DTSheet.GetParameter) and even delete a column (DTSheet.DeleteParameter) but can't find the trick to change column-header.
Any suggestions ?

Paul

[kishoreinchennai]

Code:

'add a New Colum
DataTable.GetSheet("dtGlobalSheet").AddParameter "NewColumn","Row1Value"

'copy the cells from the old column into the new column
cnt=DataTable.GetRowCount
For i=1 to cnt
       DataTable.SetCurrentRow(i)
       OldVal=DataTable.Value("OldColumn","dtGlobalSheet")
       DataTable.Value("NewColumn","dtGlobalSheet")=OldVal
Next

'delete the old column
DataTable.GetSheet("dtGlobalSheet").DeleteParameter("OldColumn")

Regards

[paulv]

Kishore,

thx for the reply.
We already had a similar option in mind, but unfortunately this way of working would be too time-consuming.
Therefor I choose for another way of working :
no longer copy our 'floating' header-definition from within the table to the header, but just read it at the position it is now.

Thanks anyway !

Paul

[kishoreinchennai]

Code:

'add a New Colum
DataTable.GetSheet("dtGlobalSheet").AddParameter "NewColumn","Row1Value"

'copy the cells from the old column into the new column
cnt=DataTable.GetRowCount
For i=1 to cnt
       DataTable.SetCurrentRow(i)
       OldVal=DataTable.Value("OldColumn","dtGlobalSheet")
       DataTable.Value("NewColumn","dtGlobalSheet")=OldVal
Next

'delete the old column
DataTable.GetSheet("dtGlobalSheet").DeleteParameter("OldColumn")

Regards