Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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!

like image 467
user2344922 Avatar asked May 02 '13 22:05

user2344922


1 Answers

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))
like image 111
Steve Avatar answered Sep 24 '22 17:09

Steve