How to insert NULL in column

Question

Hi everybody I have a integer column and I want in vb code behind that the column will be filled wiht NULL - so empty value. I try like this: Dim IInpUserKey As Nullable(Of Integer) But then I still see the vlaue 0 and not NULL in the column. Thank you

Vulpes · Answer

I take it that it's an INT column in the database. If you keep getting a zero inserted are you sure that it actually allows NULLs?

albert albert · Answer

yes I solved. Thank you

albert albert · Answer

And If I try it like this;Dim IInpUserKey As Integer = System.DBNull.Value Then I get this error: Error 39 Value of type 'System.DBNull' cannot be converted to 'Integer'.

albert albert · Answer

Yes I triied it like this: Dim IInpUserKey As Integer = DBNull.Value.ToString() But that doesnt work. And If I try like this: Dim IInpUserKey As String = DBNull.Value.ToString() Then I still get a 0 in de database

Vulpes · Answer

I'd use DBNull.Value to add a NULL value to the database. http://msdn.microsoft.com/en-us/library/system.dbnull.value(v=vs.110).aspx

How to insert "NULL" in column