nullable sqlparameter

  • Thread starter Thread starter buran
  • Start date Start date
B

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
 
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.
Click to expand...

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
 
Thanks, that worked :)

Frans Bouma said:
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
-------------------------------------------------------------------------
Click to expand...
 
Back
Top