Hi their,

This is my first module since past two weeks and I am finally look like to be close to finishing this module but it is giving me trouble with sqldatetime overflow. Can any one help me with this issue?

I have basically build a custom form with selected input and text area form and all I want to have the ability is to allow anonymous users and members to submit the form just like contact us form.

I have columsn like title, startdate, enddate, description, weburl to name the few. Any suggestion will be appreciated.

Thanks,
Wasay

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, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) 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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Witinc.Modules.EventAdd.SqlDataProvider.AddEventAdd(Int32 ModuleId, String EventName, String Location, DateTime StartDate, DateTime EndDate, String SuggestedParticipants, String Description, String CreditsOrCertification, String Cost, String ContactName, String ContactTitle, String ContactEmail, String ContactPhone, String ContactFax, String ContactAddress, String WebURL, Int32 UserId) at Witinc.Modules.EventAdd.EventAddController.AddEventAdd(EventAddInfo objEventAdd) at Witinc.Modules.EventAdd.ViewEventAdd.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---