DateTime in MS Acces with ADO.NET
-
I posted this question on the ADO.NET board, but the only reply I got was that I need to check my Update code. I have an Access database with a Date/Time column. I used the VS.NET forms designer to create an OleDbDataAdapter and DataSet from the datasource. The DataSet created has the Date/Time column with a DateTime type as expected. The Fill and Update methods work properly without exception. However, after an insert or update, the data that actually gets stored to the database has a time of 12:00:00 AM, requardless of the time I specified while running the application. One solution I have thought of, but not tried, is to change all DateTime column types in the Typed-DataSet to OleDb.Date. Thanks, Scott Page
"Some people spend an entire lifetime wondering if they made a difference. The Marines don't have that problem." ( President Ronald Reagan)