[AccessD] vb.Net - Checking for NULL values

Hi Darren,

My code is not in SQL but in VB.net.  It doesn't recognise Is Null either.

David

At 13/06/2006, you wrote:
>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