handling null's when extracting from db

[Tokhra]

Hi all,

I have the following code:

this.Address = (string) dataReader["Address"];

which creates an invalid cast exception if it returns null, whats the best way to handle this? I don't really want to have if (dataReader["Address"] != DbNull.Value) for every db extraction..there must be a better way?

Thanks,
Matt.

 

[Tokhra]

for some reason it took away the [ and ] (brackets) around the address when I submitted the post.

 

[chiph]

Yep, that's how you do it -- you have to check every field that is potentially nullable against DBNull.

You can make this easier by putting that code into it's own function (I would suggest one function for every datatype -- one for Ints, one for String, one for DateTime, etc).

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[Tokhra]

Thanks chiph - I've done what you suggested, works a treat