re: Drop Down Calendar binding and null value

I have a drop down calendar in a formview that I am binding to a SQL Data Source. The code is:

'' Format="Short" Height="17px" Width="224px" runat="server" />

The problem is that when I try to open the form for an insert when DatePurchased doesn''t have a value yet I get:

Conversion from type ''DBNull'' to type ''Date'' is not valid.
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.

I thought that adding IsNullDate="true" and EnableNullDate="true" would fix it, but it has not.

Hi Melissa,

Attached is a sample project as per your requirement. I have created this sample with 4.3.0.30 version.

 DDCalFormViewSample.zip 

Please let us know if you have any further queries.

Thanks
Sharmila

This doesn''t do entirely what I want. Your code prevents the error, but it inserts in todays date in its place and I don''t want todays date to be there I want there to be no value at all in the drop down.

Thanks,
Melissa

>Hi Melissa,

Attached is a sample project as per your requirement. I have created this sample with 4.3.0.30 version.

 DDCalFormViewSample.zip 

Please let us know if you have any further queries.

Thanks
Sharmila

Hi Melissa,

We are looking into this, we will get back to you soon.

Regards,
Sharmila

Hi Melissa,

A bug report has been logged for this issue. You can refer to this at:

http://www.syncfusion.com/support/issues/tools/Default.aspx?ToDo=view&questId=2862

We will update you once its implemented.

Thanks,
G.Pradeep.


>Hi Melissa,

We are looking into this, we will get back to you soon.

Regards,
Sharmila