[AccessD] FW: vb.Net - Checking for NULL values

Hi David
Also
Here is some SQL I was working with today
Note the Is Null at the End of the relevant field name

select JST.serviceno,  from JustSomeTable as JST
Left Join ACoolTable as ACT on JST.ServiceNo = ACT .ServiceNo

where ACT .ServiceID is null










-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Tuesday, 13 June 2006 12:52 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] vb.Net - Checking for NULL values

I am using Visual Studio 2005 Express.  I want to check whether a 
session value has been initialised and if not then set some 
values.  If there is already a value in Session("ItemAmt") then I 
don't want the values to change.  My code in the Page Load event is:

         If IsNull(Session("ItemAmt")) Then
             Session("ItemName") = "Description"
             Session("ItemAmt") = "100"
         End If

The problem is with the IsNull function.  I have not been able to 
find out the equivalent method in VB.net.  Any pointers?


Regards

David Emerson
Dalyn Software Ltd
New Zealand  
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com