Okay, I'm a beginner and I need some help. I'm getting a
"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" error.
I'm providing the lines of code that the error points to. From what I can gather from searching this forum, I need to use GetNull().
The field in question is createdDate
In the db createdDate has a data type of DateTime
-------------this is in my SQLdataprovider.vb
Public Overrides Sub UpdateCymbalX(ByVal itemID As Integer, ByVal moduleID As Integer, ByVal name As String, ByVal description As String, ByVal createdDate As DateTime) SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner & ObjectQualifier & "dpCymbalXUpdate", itemID, moduleID, name, description, createdDate)) End Sub
------------this is in my Dataprovider.vb
Public MustOverride Sub UpdateCymbalX(ByVal itemID As Integer, ByVal moduleID As Integer, ByVal name As String, ByVal description As String, ByVal createdDate As DateTime)
-------------this is in my CymXBLL.vb
Public
Sub Update(ByVal objCymbalX As CymbalXInfo)
DataProvider.Instance().UpdateCymbalX(objCymbalX.itemID, objCymbalX.ModuleID, objCymbalX.name, objCymbalX.description, objCymbalX.createdDate)
End Sub