[AccessD] vb.Net - Checking for NULL values

Hi David
Just a way out guess
In SQL Server the IsNull function is named Is Null
Is space Null rather than IsNull - one word

See if that makes a difference

Hope this helps

Darren

-----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