Trying to bind datetimepicker to bindingsource I face 2 problems:
1) The typical problem - I can't bind to nulls. Summing up, what is the
easiest way to allow datetimepicker to be bound to null?
2) This thing is about date formats in which datetimepicker stores dates. In
sql server from where I take date data, format is the following: dd/mm/yyyy
(i.e. german). Datetimepicker stores date in this format: mm/dd/yyyy. Of
course I can change output format using customformat but this is only
presentation. When I set new date in databound datetimepicker, it changes the
places of day and month. For example if I specify 10.01.2007 in DTP,
databinding binds to dataset 01.10.2007. If day value is more than 12 - I
can't commit dataset to real database.
I tried to change cultureinfo settings but that didn't helped. Please let me
know what to do?