Winform Radscheduler dadabinding meet 'System.Data.NoNullAllowedException' issue

[Mike]

Hi guys,

 

When I am doing data binding on RadScheduler(using SchedulerBindingDataSource), I meet  'System.Data.NoNullAllowedException, Column 'id' does not allow null'

My steps are:

1) Double-Click on the scheduler to create a new time slot, and custom appointment dialog show up.

2) type the info, then click ok button

3) error shows....

4) After clicking ok button, the appointment slot will show on schedule, then click the Save button, data will be saved to the database

 

However, The data populating is good. I can receive data from the database, when I run the application the data which I manually type into the database is exist on schedule. And if I click on exist appointment slot and do some changes,  there is no error. After I click save button The data will be successfully saved into the database.

 

Could you let me know which part will be the issue, All screenshots are attached.

If need more information, plz let me know,

 

Thanks,

Mike

[Dinko | Tech Support Engineer]

Hi Mike,

Thank you for the provided images.

Upon checking our feedback portal, I found that we had a similar exception logged in our Feedback Portal when an appointment is created. The issue is related to a database having fields not allowing null. This exception is already addressed. The fix was introduced a few years back so may I ask you to share which version of our controls are you using? Also, can you try the workaround mentioned in the feedback item: Workaround: remove the database restrictions and validate the data in the edit dialog before submitting the new appointment data. and let me know if it makes any difference.

Regards,
Dinko
Progress Telerik

[Mike]

Hi Dinko,

 

Thanks for the quick reply.

The 'id' is the primary key of this table, So It must not allow nulls.

And my version of Telerik Winform is 2021.2.615

 

Regards,

Mike

[Mike]

Also here in the introduction of RAdscheduler data binding article. The set ID (primary key) doesn't allow null

 

Link: https://www.telerik.com/blogs/data-binding-with-radscheduler-for-winforms?-ga=2.204391824.1060152126.1644126000-451845574.1638143444&-gac=1.82139236.1641417169.Cj0KCQiAoNWOBhCwARIsAAiHnEg9jvTcQLokuxqr8E-l7EbWimKHMxub-v-eAIvZNrDQEaVPiL4tVGMaAuH4EALw-wcB

[Dinko | Tech Support Engineer]

Hello Mike,

The problem back then was related to a field that is not primary and does not allow null values. Using only the provided information I could only guess what is the reason behind this exception. It could be a corner case in which the fix is not working correctly. Could it be possible to isolate this behavior in a standalone project with less code as possible? This way I can attach the source code on my side and debug the exception. 

Regards,
Dinko
Progress Telerik