K
Ken Cox [Microsoft MVP]
Hi,
I'm using a dataset to read data from an XML file. I don't control the XML.
The XML has no schema and therefore is treated like a string. My data
consumer wants the column type to be a Double.
Is there a simple way to change a column from string to double? When I try
to do it, the compiler complaints that I can't change the type after the
data is loaded. Maybe there's a way to do a mapping or alias? Can I create
my own schema and apply it after the data is loaded?
Thanks,
Ken
I'm using a dataset to read data from an XML file. I don't control the XML.
The XML has no schema and therefore is treated like a string. My data
consumer wants the column type to be a Double.
Is there a simple way to change a column from string to double? When I try
to do it, the compiler complaints that I can't change the type after the
data is loaded. Maybe there's a way to do a mapping or alias? Can I create
my own schema and apply it after the data is loaded?
Thanks,
Ken