Posted on: 9/21/2012 1:18:32 AM | Views : 244

Hi,
I retrieve some rows from DB and populate a DataTable; then I transform this DataTable to a List of Objects.
If some cells of the rows has DBNULL values, how is the proper way to manage this?
1: Updating DB not supporting Null values
2: Iterating DataTable and converting DBNull values to ""
3: Checking this DBNull values on the function that transforms DataTable onto List of Objetcs
4: ??????
Thanks.

---------------------------------
Ok, solved. What about using
If(datarow("field") Is DBNull.Value, "", datarow("field")
as param passed on the constructor.
...

Go to the complete details ...