problems with checking against NULL value in mssql2000 db

[excelleinc.com]

Hi,

I'm trying to check if field contains NULL value in MSSQl 2000 database but
keep receiving error.

asp.net code:

If Trim(HLSQLDSet.Tables("mfglinks").Rows(15).Item(0)) Is Null Then
URLSurgeS.Visible = "False"
End If

error:
BC30822: 'Null' is not declared. 'Null' constant is no longer supported; use
'System.DBNull' instead

I'm getting error when I use System.DBNull instead of Null.


Thanks

 

[Hermit Dave]

when comparing to a datacolumn in a dataset /datatable use
System.DbNull.value

ie something like
If Trim(HLSQLDSet.Tables("mfglinks").Rows(15).Item(0)) = System.DbNull.Value
Then
URLSurgeS.Visible = "False"
End If


--

Regards,

Hermit Dave
(http://hdave.blogspot.com)