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 <(E-Mail Removed)> wrote:
> 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.

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

--
Jon Skeet - <(E-Mail Removed)>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too