Our Training Programs

All contents are copyright of their authors.

How to insert "NULL" in column

How to insert "NULL" in column

albert albert

12yAsked Apr 16, 2014, 9:39 AM1.3kVisual Basic .NET

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

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Vulpes12y ago
Accepted 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 albert12y ago
yes, I solved. Thank you
albert albert12y ago
And If I try it like this;Dim IInpUserKey As Integer = System.DBNull.Value

Then I get this error:

Error39Value of type 'System.DBNull' cannot be converted to 'Integer'.
albert albert12y ago
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
Vulpes12y ago
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