I am in the process of testing the DatePicker to determine if I would like to purchase this feature. I am having the following issues. I hope you all can help me with this error message.

Here is some background, I am creating an ASP.NET website. I have added the DatePicker control to my DetailsView InsertItemTemplate on my form.

I have clicked on the Edit Calendar for the Datepicker and set the the datepicker attribute to PickerFormat="MM/dd/yyyy hh:mm:ss tt" I have it bound to the StartDate column in my SQL data table.

I have setup the Startdate column in my SQL table to be be datetime2(7) for the data type
I have setup the Insert Parameter to be <asp:Parameter DBType="DateTime2" Name="StartTime" />

I am getting the following error when I submit the data in my form:

Invalid cast from 'Boolean' to '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.InvalidCastException: Invalid cast from 'Boolean' to '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:


[InvalidCastException: Invalid cast from 'Boolean' to 'DateTime'.]
System.Boolean.System.IConvertible.ToDateTime(IFormatProvider provider) +134
System.Convert.ChangeType(Object value, TypeCode typeCode, IFormatProvider provider) +519
System.Web.UI.WebControls.Parameter.GetValue(Object value, String defaultValue, TypeCode type, Boolean convertEmptyStringToNull, Boolean ignoreNullableTypeChanges) +126
System.Web.UI.WebControls.Parameter.GetValue(Object value, String defaultValue, DbType dbType, Boolean convertEmptyStringToNull, Boolean ignoreNullableTypeChanges) +57
System.Web.UI.WebControls.Parameter.GetValue(Object value, Boolean ignoreNullableTypeChanges) +120
System.Web.UI.WebControls.SqlDataSourceView.AddParameters(DbCommand command, ParameterCollection reference, IDictionary parameters, IDictionary exclusionList, String oldValuesParameterFormatString) +550
System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary values) +306
System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +89
System.Web.UI.WebControls.DetailsView.HandleInsert(String commandArg, Boolean causesValidation) +379
System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +611
System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source, EventArgs e) +95
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source, EventArgs e) +112
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +125
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

I looked in my code and between the <InsertParameters> tag I have this:
<asp:Parameter DbType="DateTime2" Name="StartTime" DefaultValue="" />

I tried to change it to this:
<asp:ControlParameter ControlID="StartTime" DefaultValue="" Name="DatePicker1" PropertyName="SelectedDate" />

but that made it worse, sorry to be so without clue.

Based on the previous reply from you, I checked the Bindable Properties for the DatePicker and clicked on the Show All Properties check box and selected the "SelectedDates" and added my Custom Binding Bind("StartTime"). The datepicker worked perfectly.