469,326 Members | 1,224 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

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 2526
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 zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.