So far this is my only complaint with Strongly Typed Datasets, and I hope it is just because of lack of knowledge.
My datarow contains a decimal type field which is Null. I need to convert it to a string. When I try dr.FieldName.ToString I get a runtime error because it is DBNull. When I try dr.Item("FieldName").ToString, it works and I end up with an empty string.
When I try IIF(dr.IsFieldNameNull,"",dr.FieldName), I get an runtime error because I am assuming it is evaluating both results.
Before I have done a full IF statement, but that is going to really suck doing that for every field that could be Null. What is the recommended way of handling this?
Thanks!