Changing DataCOlumn DataType

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi,

I need to change the datatype of a datacolumn from Int16
to Int32 under certain conditions at runtime. The problem
is that the table is already populated with data, although
the data in the column to change can be removed.

I have got this working by removing the datacolumn from
the datatable, (this clears all data in the column) and
then changing the datatype before adding it again. Problem
with this is the column is added at the end.

Can a datacolumn be added back to it original position?
Or, is there another way of doing this?

Many thanks.
 
Hi George,

No, once data is inside the column you can't change its type.
Why does it matter its position?
 
Try creating an expression column with the datatype required and add a
simple expression that simply points to the original column. As long as
the types can be converted, you can progamaticly add expression columns
after data has been added.

Andrew Conrad
Microsoft Corp
http://blogs.msdn.com/aconrad/
 
However, you can't modify expression column value which might be important
for databinding.
 
Back
Top