I can check for a DBnull
on a data row using any of the methods.
Either by using
if(dr[0][0]==DBNull.Value) //do somethin
or by doing
if(dr[0][0].ToString().IsNullOrEmpty()) //do something
In Both Cases I will be getting same result.
But Which one is conecptually right approach. Which was will use less resources
DBNull represents a nonexistent value returned from the database. In a database, for example, a column in a row of a table might not contain any data whatsoever. That is, the column is considered to not exist at all instead of merely not having a value. A DBNull object represents the nonexistent column.
Rules at a Glance DbNull is not the same as Nothing or an empty string. DbNull is used to denote the fact that a variable contains a missing or nonexistent value, and it is used primarily in the context of database field values.
The first way is somewhat correct. However, more accepted way is:
if ( dr[0][0] is DBNull )
And the second way is definitely incorrect. If you use the second way, you will get true in two cases:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With