nullable sqlparameter

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,905
Latest member
Kristy_Poole

Latest Threads

Top