When you use an XML document that contains an attribute or
an element with a decimal value such as 0.00001, the schema marks that
attribute or element as a decimal. If you use the DataSet.ReadXML
method to read an XML file, and then you use the DataSet.WriteXML
method to write the value back to the XML file, the output
contains a value in scientific notation. If you use the DataSet.ReadXML
method again, you receive the following exception error
System.FormatException - Input string was not in
a correct format.
method internally calls the Decimal.ToString
method when it writes decimal numbers. The Decimal.ToString
method writes decimal numbers such as 0.00001 in scientific
notation. You cannot set the NumberStyles
enumeration for the DataSet
object to make for scientific notation be read as a decimal
value. Therefore, when you use the DataSet.ReadXML
method to read the number back into a data set, a FormatException
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.
To resolve this problem immediately, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:Note
In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question. The English
version of this hotfix has the file attributes (or later file attributes) that
are listed in the following table. The dates and times for these files are
listed in coordinated universal time (UTC). When you view the file information,
it is converted to local time. To find the difference between UTC and local
time, use the Time Zone
tab in the Date and Time tool in
Date Time Version Size File name
03-May-2002 02:17 1.0.3705.271 1,294,336 System.xml.dll
You can mark the value as a string instead of as a decimal
in the schema, and you can manually convert the string to a decimal number
value by using the Decimal.Parse
method with the AllowExponent NumberStyles
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
Steps to reproduce the behavior
This method uses a DataSet
object to read, to write, and to read a decimal value from an XML
- Create a new Microsoft Visual C# .NET console application.
- Start Microsoft Visual Studio .NET.
- On the File menu, point to
New, and then click Project.
- Under Project Types, click
Visual C# Projects, and then click Console
Application under Templates. By default, a class that
is named Class1 is created.
- Add the following using statement at the beginning of the
- Add the following code to the Main field in Class1.cs:
DataSet ds = new DataSet();
- In Solution Explorer, right-click the project name, point
to Add, and then click Add New Item. The
Add New Item box appears.
- Click XML Schema under
Templates, and then click Open. By default,
XMLSchema1 is created.
- Switch to the XML field, and then replace the coder with
the following code:
<?xml version="1.0" standalone="yes"?>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true">
<xs:element name="name" type="xs:string" minOccurs="0" />
<xs:element name="tax" type="xs:decimal" minOccurs="0" />
- Repeat step 4, click XML File under
Templates, and then click Open. By default,
XMLFile1 is created.
- Replace the code with the following code:
<?xml version="1.0" standalone="yes" ?>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<Table diffgr:id="Table1" msdata:rowOrder="0">
<Table diffgr:id="Table2" msdata:rowOrder="1">
- On the Debug menu, click
You receive the error message that is mentioned in the