we achieved good results by following:
Adding an additional datacolumn within the right datatype and using the Expression Property
after this we do remove source datatable (remove datacolumn or dtData.DefaultView…)
if needed rename the previous added datacolumn
OR
- clone datatable - dtDataC
- add a datacolumn to dtDataC (refelcting the converted datacolumn)
- using a LINQ for the conversion
- remove source datacolumn
- rename the previous added datacolumn