DateTimePicker and BindingSource Problem

[Ahmad Safwat]

Hi all, I have a problem with DateTimePicker and BindingSource. The BindingSource DataSource is a DataTable of 3 Columns (ID, Name, and Date). The "ID" Field is Primary key that of cource doesn't allow nulls. Both "ID" and "Name" fields are bound to TextBoxes, and "Date" Field is bound to a DateTimePicker control. Now when I'm trying to add a new record, I got an exception of: "Column 'ID' does not allow nulls." although it has a value. when I don't bind "Date" field, problem doesn't occur Can you help meeee?? :((

[Acid_Inex]

Take a look http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.windowsforms/topic64486.aspx[^]

[PeSVe]

Before actually adding a the new record, you should clear the datetimepicker's databinding, using the method datetimepicker1.DataBindings.Clear() in C#. After that binding the datetimepicker1 to the same data source it's bound before.