How to check if something is Null

's Computer Specifications

VB.Net 2003, Web Application

Hey there, ive looked around for ages and havnt found a straight
answer. All I want to do is find out if a field in my datatable is Null
For example

If ts.Rows(isel).Item(4) = Null Then

Do something

End if

but have no idea how to do it.. any help would be great

's Computer Specifications

If IsDbNull(ts.Rows(isel).Item(4)) Then
....
End If

"Bonzol" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> VB.Net 2003, Web Application
>
> Hey there, ive looked around for ages and havnt found a straight
> answer. All I want to do is find out if a field in my datatable is Null
> For example
>
>
> If ts.Rows(isel).Item(4) = Null Then
>
> Do something
>
> End if
>
> but have no idea how to do it.. any help would be great
>

's Computer Specifications

Bonzol wrote:

> All I want to do is find out if a field in my datatable is Null

> If ts.Rows(isel).Item(4) = Null Then
> Do something
> End if

If ts.Rows(isel).Item(4) Is System.DBNull.Value Then

HTH,
Phill W.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if date field not null or >0 check check box	JK	Microsoft Access VBA Modules	4	28th Jan 2009 03:44 PM
Check null	RP	Microsoft C# .NET	4	12th Nov 2007 04:58 PM
Check if it is null	shapper	Microsoft ASP .NET	1	11th Oct 2006 08:11 PM
Check for Null	=?Utf-8?B?S2lyayBQLg==?=	Microsoft Access Form Coding	5	25th Jul 2006 06:57 PM
How to check for null	tshad	Microsoft C# .NET	12	6th Oct 2005 01:28 AM