>I am using a Visual FoxPro OLE DB connection to pull fields out of a VFP DBF table into an ASP.NET dataset which is then bound to a datagrid. My problem is dealing with blank date fields. When the date field is blank in the DBF table it shows up in the datagrid with the date "12/30/1899 12:00:00 AM". I am new to ASP.NET and am becoming frustrated trying to solve this. There has to be an easy way to fix this.
The ODBC driver/OLE DB provider don't support empty dates. Use Nulls instead or convert emoty dates to Nulls in your query.
--sb--