That worked, thanks.  

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-----Original Message-----
From: Iain Smallwood [mailto:IainS@;tmcs.co.uk] 
Sent: Thursday, October 24, 2002 10:21 AM
To: dotnet
Subject: RE: VB.NET System.DbNULL error

Try 

If Not 
Database.table("select_all").Rows(DbCurrent).Item("score") Is
System.DBNull.VALUE) Then...

Cheers,
Iain

-----Original Message-----
From: Matthew Small [mailto:matt7@;showstopperonline.com] 
Sent: 24 October 2002 14:49
To: dotnet
Subject: VB.NET System.DbNULL error


I'm keep getting an error trying to use system.DbNULL, but I can't use
NULL either.  What's the deal?

Error:
'DBNull' is a type in 'System' and cannot be used as an expression.


Code:
If Not 
Database.table("select_all").Rows(DbCurrent).Item("score") Is
System.DBNull) Then

TotalScore.Text =
Database.table("select_all").Rows(DbCurrent).Item("score").ToString()

End If



Thanks

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com



---
You are currently subscribed to dotnet as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%

---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/
 
Disclaimer
This message may contain information which is legally privileged and/or
confidential.  If you are not the intended recipient, you are hereby
notified that any unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited.  Such notification not
withstanding, any comments or opinions expressed are those of the
originator, not of Taylor Made Computer Solutions, unless otherwise
explicitly stated.
 
 

---
You are currently subscribed to dotnet as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%

---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/






---
You are currently subscribed to dotnet as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/


Reply via email to