nullable sqlparameter

[buran]

Dear ASP.NET Programmers,

How can I make an sqlparamater accept NULL value programmatically? I use the
following the code, but it does not work:

Dim admDate As SqlParameter
admDate = New SqlParameter("@admissionDate", SqlDbType.SmallDateTime)
admDate.isNullable = True
admDate.Value = CType(admissionDate, Date).Date.ToString("dd.MM.yyyy")

The compliler throws an exception when passing System.DBNull value to the
sqlparamater admDate.
Thanks in advance,

Buran

 

[Frans Bouma]

Dear ASP.NET Programmers,

How can I make an sqlparamater accept NULL value programmatically? I use
the following the code, but it does not work:

Dim admDate As SqlParameter
admDate = New SqlParameter("@admissionDate", SqlDbType.SmallDateTime)
admDate.isNullable = True
admDate.Value = CType(admissionDate, Date).Date.ToString("dd.MM.yyyy")

The compliler throws an exception when passing System.DBNull value to
the sqlparamater admDate.

if you do:
amdDate.Value = System.DBNull.Value

this throws an exception? Which one?

You can also pass: nothing, or simply do not pass a value, it will be NULL
automatically. (if my memory doesn't fool me )

FB

 

[buran]

Thanks, that worked

if you do:
amdDate.Value = System.DBNull.Value

this throws an exception? Which one?

You can also pass: nothing, or simply do not pass a value, it will be NULL
automatically. (if my memory doesn't fool me )

FB

--
Solutions Design : http://www.sd.nl
My open source .NET Software : http://www.sd.nl/software
My .NET Blog : http://weblogs.asp.net/FBouma
-------------------------------------------------------------------------