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

[Prabhudhas Peter]

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.
--
Peter...

[Chris Podmore]

Do you mean System.DBNull.Value?

Chris.

"Prabhudhas Peter" wrote:

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.
--
Peter...

[Herfried K. Wagner [MVP]]

"Prabhudhas Peter" <Pr*************@discussions.microsoft.com> schrieb:

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'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[james]

Something like this:
myvalue = DBNull.Value

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

james

"Prabhudhas Peter" <Pr*************@discussions.microsoft.com> wrote in message
news:F7**********************************@microsof t.com...

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.
--
Peter...