Need Help Resolving SQLDateTime overflow error
<p>Can anyone assist with this error?<br>
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.</p>

<p>Here's my code:</p>

<pre><code> &lt;DataObjectMethod(DataObjectMethodType.Update)&gt; _
    Public Shared Sub UpdateIncident( _
                                    ByVal DateClosed As DateTime, _
                                    ByVal Description As String, _
                                    ByVal original_IncidentID As Integer, _
                                    ByVal original_ProductCode As String, _
                                    ByVal original_DateOpened As DateTime, _
                                    ByVal original_DateClosed As DateTime, _
                                    ByVal original_Title As String, _
                                    ByVal original_Description As String, _
                                    ByVal IncidentID As Integer, _
                                    ByVal ProductCode As String, _
                                    ByVal DateOpened As DateTime, _
                                    ByVal Title As String)
        Dim con As New SqlConnection(GetConnectionString)
        Dim up As String = "UPDATE Incidents " _
           &amp; "SET DateClosed = @DateClosed, " _
           &amp; "Description = @Description" _
           &amp; "WHERE IncidentID = @original_IncidentID " _
           &amp; "AND ProductCode = @original_ProductCode " _
           &amp; "AND DateOpened = @original_DateOpened " _
           &amp; "AND (DateClosed = @original_DateClosed " _
           &amp; "OR DateClosed IS NULL " _
           &amp; "AND @original_DateClosed IS NULL) " _
           &amp; "AND Title = @original_Title " _
           &amp; "AND Description = @original_Description"
        Dim cmd As New SqlCommand(up, con)
        If DateClosed = #12:00:00 AM# Then
            cmd.Parameters.AddWithValue("DateClosed", DBNull.Value)
        Else
            cmd.Parameters.AddWithValue("DateClosed", DateClosed)
            cmd.Parameters("DateClosed").DbType = DbType.DateTime
        End If
        cmd.Parameters.AddWithValue("Description", Description)
        cmd.Parameters.AddWithValue("original_IncidentID", original_IncidentID)
        cmd.Parameters.AddWithValue("original_ProductCode", original_ProductCode)
        cmd.Parameters.AddWithValue("original_DateOpened", original_DateOpened)
        cmd.Parameters("original_DateOpened").DbType = DbType.DateTime
        If original_DateClosed = #12:00:00 AM# Then
            cmd.Parameters.AddWithValue("original_DateClosed", original_DateClosed)
        Else
            cmd.Parameters.AddWithValue("original_DateClosed", original_DateClosed)
            cmd.Parameters("original_DateClosed").DbType = DbType.DateTime
        End If
        cmd.Parameters.AddWithValue("original_Title", original_Title)
        cmd.Parameters.AddWithValue("original_Description", original_Description)
        con.Open()
        cmd.ExecuteNonQuery()
        con.Close()
    End Sub
</code></pre>
