[RESOLVED] how to enter null value ?

[techgnome]

Ungh... ok... well then try this:

        cmd.Parameters.AddWithValue("pet", pretTxt.Text)
        cmd.Parameters.AddWithValue("ppa", prpaTxt.Text)
        if not pretTxt.Enabled Then
            cmd.Parameters("pet").Value = DBNull.Value
        End If

You'd think there was an easier way to deal with this... oh well...

And I'd swear the pevious example works... I may have to go back and see just exactlky what I did.

-tg