Saving retrieving DataSet

[Guest]

I have a DataSet with different types of data i.e. string, int , bool, etc.
When i save it using the default WriteXml method, the data types are lost.
When I use WriteXml(xmlWriter, XmlWriteMode.WriteSchema) method, I am getting
the types in the file, but i am getting an exception when trying to read it.

The default method suppose to work according to the documetation to
DataSet.ReadXml, but it does not!

Is there a way to save retrieve a DataSet without loosing the data types?

Thanks,

Val

 

[Peter Bromberg [C# MVP]]

The XmlWriteMode parameter--

http://msdn.microsoft.com/library/d...tml/frlrfsystemdataxmlwritemodeclasstopic.asp

provides the option to save a Schema .
Peter

 

[Guest]

That is exactly what i was using, but I cannot read it then without causing
an exception!

 

[carion1]

Did you close the writer?

 

[Guest]

Of course!!! I even do it during different sessions!