How to assign a null value to the Column in the Database from VB.N

[Guest]

I want to assign null value to a column in the database which is decalred as
an integer from VB.net...

Is there any specific keyword like vbNull as in vb 6.0.

 

[Guest]

Do you mean System.DBNull.Value?

Chris.

 

[Herfried K. Wagner [MVP]]

I want to assign null value to a column in the database which is decalred
as
an integer from VB.net...

Is there any specific keyword like vbNull as in vb 6.0.

Assign 'SqlInt32.Null' to the 'Value' property of your 'SqlInt32', if you
are using the 'Sql*' types. For a more general replacement, take a look at
'DBNull.Value'.

 

[james]

Something like this:
myvalue = DBNull.Value

That will set the column's value (myvalue in this case) to DBNull.Value.

james