Does anyone have any suggestions for efficient ways to debug database problems? For example, my working code recently quit working on the following statement:
OleDbDataAdapter1.Update(DataSet1)
The error is:
A first chance exception of type 'System.FormatException' occurred in mscorlib.dll
Additional information: String was not recognized as a valid Boolean.
It looks like there's a field mismatch between the dataset & the underlying database which I am trying to update. All I need to do is to figure out which fields are mismatched.
My usual approach of breaking out into the debugger is not helpful, because the dataset structure is endlessly nested & takes forever to interpret.
Any suggestions are welcome.
