Assigning a null value

[ArielR]

How can assign a null value to a field that is integer but allows null value.? int? nullval = null; mydataSet.mytable[myBindingSource.Position].myIntField = nullval ; isn't found.....

[Lost User]

Have you tried DBNull.Value? regards

[ArielR]

yes, when compile have this error: "cannot implicitly convert type 'System.DBNull.value' to int"

[Dave Kreskowiak]

Of course not. You have to rewrite that little bit of assignment code you posted to check for a null value in the int, and then, if null, you have to assign DBNull.Value to your database column.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008

[PIEBALDconsult]

You don't need the local variable.

[ArielR]

I solved it that way... mydataSet.mytable[myBindingSource.Position].SetmyIntFieldNull(); Thank you very much...