parameterized sql...dbnull value?

I should know this, but I don't...

How do I enter a null value in an integer field using parameterized SQL?

I have this:

Dim bonding2ID As Integer
If cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString) =
"none" Then
bonding2ID = DBNull.Value
Else
bonding2ID =
cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString)
End If

But it's not liking the 'DBNull.Value' part.

-Darrel

================================================== ===============
Win prizes searching google:
http://www.blingo.com/friends?ref=h...FnTqhv-2GE1FNtAHi,
I think u r corret.

Try System.DbNull.Value to store a NULL value.

Regards,
Bharti Kumar.

darrel wrote:

Quote:

Originally Posted by

I should know this, but I don't...
>
How do I enter a null value in an integer field using parameterized SQL?
>
I have this:
>
Dim bonding2ID As Integer
If cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString) =
"none" Then
bonding2ID = DBNull.Value
Else
bonding2ID =
cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString)
End If
>
But it's not liking the 'DBNull.Value' part.
>
-Darrel
>
================================================== ===============
Win prizes searching google:
http://www.blingo.com/friends?ref=h...FnTqhv-2GE1FNtA

There's no easy way...you can use a nullable type in 2.0, but that only gets
you 1/2 way there anyways.

Write it as a method that returns an object *shrug*

function GetBondId() as object
if BLAH
return DBNull.Value
end if
return cleanSQLinput(BLAHx)
end function

Karl

--
http://www.openmymind.net/
"darrel" <notreal@.nowhere.comwrote in message
news:efGE9nunGHA.2312@.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

>I should know this, but I don't...
>
How do I enter a null value in an integer field using parameterized SQL?
>
I have this:
>
Dim bonding2ID As Integer
If cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString) =
"none" Then
bonding2ID = DBNull.Value
Else
bonding2ID =
cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString)
End If
>
But it's not liking the 'DBNull.Value' part.
>
-Darrel
>
================================================== ===============
Win prizes searching google:
http://www.blingo.com/friends?ref=h...FnTqhv-2GE1FNtA
>

his problem is assigning DBNull.Value to an integer...which you can't.

Karl

--
http://www.openmymind.net/
"Bharathi Kumar" <bharathidotnet@.gmail.comwrote in message
news:1151984411.441988.178080@.m79g2000cwm.googlegr oups.com...

Quote:

Originally Posted by

Hi,
I think u r corret.
>
Try System.DbNull.Value to store a NULL value.
>
>
Regards,
Bharti Kumar.
>
>
darrel wrote:

Quote:

Originally Posted by

>I should know this, but I don't...
>>
>How do I enter a null value in an integer field using parameterized SQL?
>>
>I have this:
>>
>Dim bonding2ID As Integer
>If cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString) =
>"none" Then
>bonding2ID = DBNull.Value
>Else
>bonding2ID =
>cleanSQLinput(DropDownList_bondingCo2.SelectedItem .Value.ToString)
>End If
>>
>But it's not liking the 'DBNull.Value' part.
>>
>-Darrel
>>
>================================================== ===============
>Win prizes searching google:
>http://www.blingo.com/friends?ref=h...FnTqhv-2GE1FNtA

>

There's no easy way...

Damn.

Quote:

Originally Posted by

function GetBondId() as object
if BLAH
return DBNull.Value
end if
return cleanSQLinput(BLAHx)
end function

So, I'm basically just returning two different types of objects? I'll give
that a shot.

Out of curiosity, what kind of object DOES accept null values?

-Darrel
System.Object is the only one I know about. Even Nullable types in 2.0 don't
natively support a database's NULL value (which makes this pretty useless)

Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/
"darrel" <notreal@.nowhere.comwrote in message
news:umQwPFEoGHA.4232@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

Quote:

Originally Posted by

>There's no easy way...

>
Damn.
>

Quote:

Originally Posted by

>function GetBondId() as object
> if BLAH
> return DBNull.Value
> end if
> return cleanSQLinput(BLAHx)
>end function

>
So, I'm basically just returning two different types of objects? I'll give
that a shot.
>
Out of curiosity, what kind of object DOES accept null values?
>
-Darrel
>