Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blank FoxPro Date Fields in ASP.NET Datagrid
Message
 
 
To
28/10/2005 15:47:50
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01063118
Message ID:
01063157
Views:
10
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform