Here's a question on reading and writing XML Files.
Suppose I pull down some data from SQL Server into a DataSet. The data is a Customer ID [an integer type], and a description [character]. The contents of the data set honor the data types [int and char].
Then I write that dataset to an XML file, close the application, then re-open the application and read the XML file into a blank dataset, like so...
DataSet Ds = new DataSet();
Ds.ReadXML("c:\\mymasterfile.xml");
The data comes back in, but both data types are character. Is there any way, when I originally write out the XML file, that I can get it to retain the data types, such that when I read the XML file back in, I get one integer column and one character column?
Thanks,
Kevin