DayPilot Forums

I am receiving the following error when attemping to run a page with the Scheduler control on it:
String was not recognized as a valid DateTime.

I have the DataSourceID set to an ObjectDataSource which returns data from a table adapter.The DataStartField and DataEndField are set to columns in the database that are of type DateTime. Is there some specific format that the date properties are looking for?

The input data for start and end columns are converted to DateTime using Convert.ToDateTime(). Can you post the exception stack trace?

String was not recognized as a valid DateTime.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: String was not recognized as a valid DateTime.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[FormatException: String was not recognized as a valid DateTime.]
System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) +2228162
System.DateTime.Parse(String s, IFormatProvider provider) +26
System.Convert.ToDateTime(String value) +86
DayPilot.Web.Ui.DayPilotScheduler.PerformDataBinding(IEnumerable retrievedData) +617
DayPilot.Web.Ui.DayPilotScheduler.OnDataSourceViewSelectCallback(IEnumerable retrievedData) +61
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +29
DayPilot.Web.Ui.DayPilotScheduler.PerformSelect() +110
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e) +19
DayPilot.Web.Ui.DayPilotScheduler.OnPreRender(EventArgs e) +33
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

I've added custom exception handling for loading DataStartField and DataEndField values. It shows what string was causing the problem in the exception message.
This fix will be included in the next release. If you want to test it now, contact me at daypilot @ annpoint.com and I will send it to you.

Ok, I sent you an email. Thanks!

Has this issue been fixed in newest version, DayPilot Pro 5.0?

This error will happen when you try to assign a database column with values that are not convertible to DateTime to either DataStartField or DataEndField.

Please let me know if you believe the problem is somewhere else.