null value integer

[ypul]

How can I assign dbnull.value to and integer variable in asp.net?

Private Active As Integer

my code checks for 3 values of "Active" Variable (null,0,1)

 

[Karl Seguin]

You can't.

In 2.0 you'll have nullable types which will make this possible.

if you need to know 'cuz you are assigning a value to a parameter for a
query, you do:

command.Parameters.Add("@SomeName", SqlDbType.Int)
if (something is null)
command.Parameters(@SomeName).Value = DBNull.Value
else
command.Parameters(@SomeName).Value = whatever
end if

Karl