You can set NULL values for datetime values in your update parameters by using DBNull.value.

SqlPar(0) = New SqlClient.SqlParameter("@CreatedOn", DBNull.Value)

You can not use vbnull for null values. It sets the date to the lowest available value which varies (2.1.1900 for me).

Popularity: 8% [?]

Tags: Microsoft, Microsoft SQL Server, Visual Basic