[AccessD] vb.Net - Checking for NULL values

If you're using a typed dataset, most of the fields with have an IsNull
property and a SetNull method.  So if Session were a typed dataset
(which means it would recognize ItemAmt and ItemName as fields, you'd do
this:

If Session.IsItemAmtNull Then
	Session.itemName = "Description"
	Session.ItemAmt = "100"
End If 

You can't actually compare those fields to Null because you get a null
exception error when you try.  You have to use the built in properties.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Monday, June 12, 2006 7: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