[AccessD] vb.Net - Checking for NULL values

William Hindman wdhindman at dejpolsystems.com
Tue Jun 13 09:49:59 CDT 2006


From: "William Hindman" <william at dejpolsystems.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, June 13, 2006 12:44 AM
Subject: Re: [AccessD] vb.Net - Checking for NULL values


David

...try "IsDBNull" instead of IsNull.

 William

> ----- Original Message ----- 
> From: "David Emerson" <newsgrps at dalyn.co.nz>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, June 13, 2006 12:09 AM
> Subject: Re: [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
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> 






More information about the AccessD mailing list