Generated DataTables and handling null values

[jehugaleahsa]

Hello:

Is there a way to handle null values for ints, DateTime, etc. in
generated DataTables?

It seems it is not something the Microsoft crew thought of. That is
hard for me to believe.

Thanks,
Travis

 

[Nicholas Paldino [.NET/C# MVP]]

Travis,

While I don't like it, for typed data sets, you have to use the
Is<column>Null property to determine if the value in a particular column is
null. It sucks, trust me.

If you are checking against a value in a plain old data row, then you
can check against the static Value field on the DBNull class. If the value
in the field is null, then it will return true when compared to that.
Otherwise, you can get your scalar value.

 

[bob clegg]

Hello:

Is there a way to handle null values for ints, DateTime, etc. in
generated DataTables?

It seems it is not something the Microsoft crew thought of. That is
hard for me to believe.

Thanks,
Travis

Another option is if(String.IsNullOrEmpty(dr[n].ToString()))
before trying to use the value.
nullable types may also be of use to you for your value types.
hth
Bob