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.

Re: Change DataRow Column Type by Jon

Jon
Thu Jan 08 11:37:36 CST 2004

Scott D <sdavenport@sigcom.net> 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 - <skeet@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too