Change the data type of cell value at runtime

Question

We are reading xml files in an UltraGrid using below code, with this code we can be able to read any xml file data into UltraGrid. But the problem with the Data Type of a column. While reading XML it's taking column data type as String. Due to that we are facing issue with the scientic number in the column.

`DataSet myDataSet = new DataSet(); myDataSet.ReadXml(_filePath); ultraGrid1.DataSource = myDataSet; we found that we can define the schema file for the data type. But it would not work in our case, we are reading any xml file and we can't define schema for each file. Do we have any other alternative to solve the below problems with XML datasource of the UltraGrid.

Scientific numbers in a cell (We want real number instead)

So, I want to change the datatype at run time according to the value.

Here the datatype is bool but there is an issue with this so i want to convert it to string:

Any way to do this?