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.

4 Replies

AD Administrator Syncfusion Team October 5, 2006 12:16 PM UTC

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


ME Melissa October 10, 2006 01:12 PM UTC

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


AD Administrator Syncfusion Team October 11, 2006 02:24 PM UTC

Hi Melissa,

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

Regards,
Sharmila


AD Administrator Syncfusion Team October 17, 2006 02:53 PM UTC

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

Loader.
Up arrow icon