I need to be able to set a int column in SQL2005 to null once in a while, within a parameter construct, i.e.

cmd.Parameters.Add(New SqlParameter("@fkSecondLevelPageID", 'null'))

I've tried 'null', vbNull and "", but none of them do the job.

Thanks!

Aaron

Hi Aaron,

You need to use DBNull.Value instead of null.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Thanks again, Imar.

:D

You're welcome once again... ;)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004