How to detect NULL in SQL-table with VB.net ?

Hi,
I want to check with VB.net whether a field in a SQL-table is NULL or not.
This code doesnot work:
If xxx = NULL then
<statements>
End If
I got the error, that NULL is not supported ?
How do I code the check ?
Help is appreciated, Gr.

Hi,

it would beDBNull.Value oryou can also useIsDBNull function (returns boolean based on if the given object has DBNull value)

|||Joteke, thanks a lot for you help,
regards from the North Sea, Ger.

How to Deploye VB.net Application Along With Database....Please Help.

Hi Guys,
I had a little Problem With My Application Deployment.

I want To Make Setup For My Application(VB.NET) Such that When it begins To Install,The Database Of the Application Will Automaticallly Get Installed.....
Even I have Generated Script For That But I dont Know How to Execute It With Installation File.I have made Complete Setup Of My Application Exept Database.

Now,I want Few Code Lines To Execute My Database Script.
So how can i Execute My Script Through Installation..

And Also If there is another Way To Accomplish This Please Suggest Me.

All Suggestions Will be Accepted...

Thanx In Advance..WOuld C# code also be ok for you ? :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||yes it will be ok for me..