finding column/row that causes System.Number.FormatException
I'm reading in xml into a dataset. I'm having to mess around with the
types of the xsd as well, since there are many null values in the
data. The data is about 25% string, 10% int, the rest decimals.
When I read this data in I frequently get a
System.Number.FormatException. No surprise, since I'm messing with
types in the xsd. But there is no indication of what row, column or
string caused the error. So I'm doing this by process of elimination.
Which is taking forever, due to the presence of nulls. I have no
ability to modify the data really.
Is there *any* way to set a breakpoint on
System.Number.ConvertToNumber()? That might not be the exact method
call... The exception has no data, the innerexception is null and the
msg tells me basically nothing. Grr.
Also, there are several thousand rows in about 85 tables.
Date:Sun, 15 Jul 2007 04:35:26 -0000
Author:
|