How I may receive DataSet with small decimal using remote object ?

Question

I use Remote object and have a problem which is : DataSet ds = db.ExecuteSPDataSet(StoredProcedure) ds - DataSet db - remote object ExecuteSPDataSet - method returning DataSet with DataTable with Column of type Decimal if values too small like 0.000004 I have a Problem with transfering DataSet I get an exception on client side: -------------------------- begin text exception An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll Additional information: Exception has been thrown by the target of an invocation. --------------------end text excception on server side I get : ----------------------------------- begin text exception An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll Additional information: Input string was not in a correct format. --------------------end text excception Have any ideas ?

Administrator · Answer

I am afraid I can't offer a direct solution but a couple of things to try could be: Have you tried serializing the DataSet out to XML looking at the values for the decimal as strings...and then taking those values and trying to use the Convert class to recreate the Decimal? Also deserialize from Xml back to the DataSet. After that try serializing the DataSet out as binary and then deserializing it. I'd suspect that this should have exactly the same behaviour as going via remoting. It could be worth holding the value in the DataSet as a Double or a String and converting to Decimal when necessary (from Decimal to Double may cause a loss of precision). Regards Liam