Send a null value to a database (conditional)

[BukHix]

How I do I send an actual null value to an SQL database? Right now I am sending a empty string but I have to change that to a null. I thought something like this would work but I must be missing something.

Dim strCityTax As String
 
        If txtCityTax.Text = "" Then
            strCityTax = DBNull
        Else
            strCityTax = txtCityTax.Text
        End If

That puts a squiggly line under the DBNull with this warning: 'DBNull' is a type and cannot be used as an expression.

[CattleRustler]

the db needs to be able to accept nulls, then send vbNullString

[BukHix]

CattleRustler does that send an emtpy string? I ask because when I go to the field in the database I am not getting the <NULL> to show that the field is indeed null. I get the same type of behavior that I would with an empty string.

[CattleRustler]

what I mean is the field in the db needs to be set to accept null values, then you can send vbNullString from code. If field is set not to accept nulls then you should be able to send "" empty string because it is not theoretically null. Different db's and programming languages may each handle this differently.

[MagellanTX]

Try this..

strCityTax = DBNull.Value

HTH