I am trying to develop a module for dnn 4.3.5

 

I am using the following tools

VS 2005

SQL Server 2003

 

I am getting the following error after i hooked it up to my stored procedures

 

DotNetNuke.Services.Exceptions.ModuleLoadException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. ---> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) at System.Data.SqlTypes.SqlDateTime..ctor(DateTime value) at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at YourCompany.Modules.First.SqlDataProvider.AddFirst(Int32 portalID, Int32 moduleID, String title, String text, DateTime dateAdd, DateTime dateMod) in C:\DotNetNukeDevelop\App_Code\First\SqlDataProvider.vb:line 135 at YourCompany.Modules.First.FirstController.Add(FirstInfo objFirst) in C:\DotNetNukeDevelop\App_Code\First\FirstController.vb:line 28 at YourCompany.Modules.First.EditFirst.cmdUpdate_Click(Object sender, EventArgs e) in C:\DotNetNukeDevelop\DesktopModules\First\EditFirst.ascx.vb:line 150 --- End of inner exception stack trace ---

 

 

I know the problem is that for some odd reason it is not accepting any dates past 12/31/1999.  My question is WHY, and what can I do to fix this

 

I use Null.NullDate which is similar to 1-1-1001 etc... why does the DNN DataProvider not make a real Null of them so that the stored procedures do not throw that error? Or is there a way to do this automatically? Programming

if(myDate == Null.NullDate)
{
   spDateValue = null;
}

is quite cumbersome. Any suggestions?

I am using a generated DAL+ data provider. It seems the MS Application blocks does not make Null of a Null.NullDate So the 1/1/1001 00.00.00 value is out of scope as you say. But I thought that the MS application blocks would make a NULL of it. I would rather prefer to use a DateTime? in which I can store a Null value instead of the Null.NullDate which will not get converted. What do you think?