Fix DBNull Conversion Errors
Thursday, August 2nd, 2007I had this really annoying problem earlier today with binding strongly typed datasets to a textbox. The fields I was binding from was sometimes null, causing this conversion exception that I couldn't figure out how to catch. Turns out there's a property for each field in the dataset called NullValue. Changing this property from "Throw Exception" to "Null" solved the problem.
I found this solution here. Thanks jcrabtressla.