Well, the project I am working on has now come to a screeching halt! I
have been developing a program that heavily utilizes ADO.NET record
sets. To generate reports, I convert the recordset to XML, and then
apply an XSLT to transform the XML into HTML. This works great (or
did) until today. I just found out that the "number-format" command in
XSLT can't handle scientific notation! So when I try to format these
numbers I just get "NaN" on the output report!!!
There are only two solutions I can see, and don't know how to
implement either of them. One would be to get XSLT to recognize
scientific notation (not going to happen by me). The other would be to
get the ADO.NET "writeXML" (or more specifically, the XmlDataDocument
class constructor) to not put the recordset double values into
scientific notation (it doesn't do that for all of them, just some of
the numbers).
Can someone help me with a solution? I've been searching the net all
day and don't see any options! I don't want to have to
re-think/re-write the entire reporting structure for my program!
I'm using VB.NET under Visual Studio.NET 2003 with the 1.1 Framework.
Thanks for any help!
---Nick