re: Drop Down Calendar binding and null value

[Melissa]

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.

[Administrator]

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

[Melissa]

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

[Administrator]

Hi Melissa,

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

Regards,
Sharmila

[Administrator]

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