Npgsql parameters with NULL value, vb.net
I'm running through a loop adding parameters, when I get to a NULL, the program punts. My statement looks like this:
mysql = "Insert into TABLE (field1) VALUES (:Col1)"
mycomm = New NpgsqlCommand (mySQL, conn)
myComm.Parameters.Add("Col" & cCnt, NpgsqlTypes.NpgsqlDbType.Double).Value = Obj.value
myComm.ExecuteNonQuery()
This works fine if Obj.value is not empty, but if Obj.value is nothing, my Execute statement fails. I'd like to just insert a NULL value into the DB. Any ideas? Thanks for any help!
To insert a NULL value in the database field, you need to pass the DBNull.Value to your parameter
You could use the VB.NET ternary operator to check if Obj itself is Nothing or if Obj.Value is nothing and in that case (true) pass the DBNull.Value instead of the Obj.Value
myComm.Parameters.Add("Col" & cCnt, NpgsqlTypes.NpgsqlDbType.Double).Value =
If(Obj Is Nothing OrElse Obj.Value Is Nothing, DBNull.Value, Obj.value))
上一篇: VB LINQ到SQL isnull