472,131 Members | 1,312 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,131 software developers and data experts.

DataSet.WriteXML writes decimals in Scientific Notation

I have a DataSet that contains a table with about 6 columns of high accuracy
decimal values. When I try to write out the DataSet using the WriteXML()
function the XML is written fine, but the decimal values are written out in
scientific notation ("9.984348392E+08"). This wouldn't be a problem except
when I try to READ the XML file back into a DataSet I keep getting a
System.FormatException saying "Input string was not in a correct format." Is
there a way to get the DataSet to write out the number without using
Scientific Notation? Or is there someway to have it parse the scientific
notation when reading the numbers in? Thanks for any help.

Smoke

May 26 '06 #1
2 2642
See http://support.microsoft.com/default...en-us%3B321542

MS has a hot fix for this issue.

Cheers,

Greg Young
MVP - C#
"rSmoke" <rS****@discussions.microsoft.com> wrote in message
news:E2**********************************@microsof t.com...
I have a DataSet that contains a table with about 6 columns of high
accuracy
decimal values. When I try to write out the DataSet using the WriteXML()
function the XML is written fine, but the decimal values are written out
in
scientific notation ("9.984348392E+08"). This wouldn't be a problem except
when I try to READ the XML file back into a DataSet I keep getting a
System.FormatException saying "Input string was not in a correct format."
Is
there a way to get the DataSet to write out the number without using
Scientific Notation? Or is there someway to have it parse the scientific
notation when reading the numbers in? Thanks for any help.

Smoke

May 27 '06 #2
Thanks for the link!

"Greg Young" wrote:
See http://support.microsoft.com/default...en-us%3B321542

MS has a hot fix for this issue.

Cheers,

Greg Young
MVP - C#
"rSmoke" <rS****@discussions.microsoft.com> wrote in message
news:E2**********************************@microsof t.com...
I have a DataSet that contains a table with about 6 columns of high
accuracy
decimal values. When I try to write out the DataSet using the WriteXML()
function the XML is written fine, but the decimal values are written out
in
scientific notation ("9.984348392E+08"). This wouldn't be a problem except
when I try to READ the XML file back into a DataSet I keep getting a
System.FormatException saying "Input string was not in a correct format."
Is
there a way to get the DataSet to write out the number without using
Scientific Notation? Or is there someway to have it parse the scientific
notation when reading the numbers in? Thanks for any help.

Smoke


May 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Joe98765 | last post: by
2 posts views Thread by David Richards | last post: by
3 posts views Thread by Sin Jeong-hun | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.