We are converting a Foxpro database to SQL and all the "empty" dates became 01/01/1900 in SQL. When we bind the data to a textbox, it display 01/01/1900 which is very confusing for the customer. If we programmatically set the empty dates to NULL values, it display blanks in the textbox. However, when we bind the field to a datepicker control, the control can't handle NULL value and give a casting error.
What should be change to get the datepicker working? The control or the structure? And how?
Thank you
Stephen Lee
--------------------------------
Too much to code
Too little time
--------------------------------