Hi,I am using vs 2003 to create a win app.It has got a datetimepicker and it is bound to a datecolumn using its text property.
I am using the following code to add a new record
this.BindingContext[dsEDiary1,"Expenditure"].AddNew();
But the problem is,when i try to save the record without selecting a date it is giving an error saying "Column 'dateCol' doesnot allow nulls".When i select a date,its working fine. But i dont wanna select date everytime i enter a new record.I wanna set a default date like toyays date or the date on which i added the earlier record.I am going crazy due to this error.Plz help me.

Cheers!!!

when u add new record just check if its null then assign todays date.