How can i change columnames in a datatable

[Lars E]

Hi

How can i change the columnames in a datatable. I am not using sql and i get
the datatable from a dataset.

The columnames in table "CustCont" is today "cc-custno1", "cc-custno2" and
"cc-class".

I think the "-" in the columnames gives me problem when doing
datatable.select() later on.

Please help



LarsE

 

[Greg Young [MVP]]

If you have chars like '-' in your column name you need to surround the
column name with [column] for the select (just like in SQL)

Aside from that you can change the column name using
http://msdn2.microsoft.com/en-US/library/system.data.datacolumn.columnname.aspx

Cheers,

Greg