Checking for DBNull

[Sreppohcdoow]

Since Operator '==' cannot be applied to operands of type 'string' and
'System.DBNull'

What is the best way to accomplish:

if(myString == DBNull.Value)
myString=""

Thx,
MS

 

[William \(Bill\) Vaughn]

It really depends on your datatype.
Dim x As SqlTypes.SqlString = SqlTypes.SqlString.Null
If x.IsNull Then
x = ""
End If

works for SqlClient datatypes as they can be set to NULL. That said, the
untyped DataTable contains objects for all of the columns which can be NULL

So this works...

Dim y As Object = DBNull.Value
If y Is DBNull.Value Then
y = ""
End If

And so does this:

Dim z As String

If z Is DBNull.Value Then

z = ""

End If

If String.IsNullOrEmpty(z) Then

z = ""

End If

Make sense?

--

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Ryan Olshan]

if (System.Convert.IsDbNull(SomeColumn)) { ... }


Thank you,
Ryan Olshan
Website - http://www.StrongTypes.com
Group - http://groups.yahoo.com/group/StrongTypes
Blog - http://blogs.strongcoders.com/blogs/ryan/