Change DataRow Column Type

  • Thread starter Thread starter Scott D
  • Start date Start date
S

Scott D

I want to be able to change the Column Type in a Dataset from the
imported data type which is Integer to data type string.

The reasoning for this is due to the fact that in the relational
database I store an integer in place of the string due to
relationships between the tables in the database. When I fill the
dataset the column is then an integer but what I need to display in
the column is the string that is associated with the integer in the
table relationship. I am comfortable maniuplating the data within the
dataset but am having a casting problem.
 
Scott D said:
I want to be able to change the Column Type in a Dataset from the
imported data type which is Integer to data type string.

The reasoning for this is due to the fact that in the relational
database I store an integer in place of the string due to
relationships between the tables in the database. When I fill the
dataset the column is then an integer but what I need to display in
the column is the string that is associated with the integer in the
table relationship. I am comfortable maniuplating the data within the
dataset but am having a casting problem.
Click to expand...

I would suggest adding an extra (derived) column, rather than trying to
change an existing one.
 
Back
Top