Copy one datatable having Columns of different dataType to other and change the column Datatype

[aslam_ali1 (aslam ali)]

Hello friends,

I have a data table which have column with different dataType. I want to convert all column into string type and store in a different table for easy calculations.

Anyone please help me.

Thanks in advance.

[Yoichi]

Hi,

Can you try the following sample?

Create DataTable which has string type columns in advance, then

 dtResult = dt.AsEnumerable.Select(Function(r) dtResult.LoadDataRow(r.ItemArray.Select(Function(o) o.ToString).ToArray(),False)).CopyToDataTable()

Sample20231105-2L.zip (3.2 KB)

Regards,