I am having trouble getting the DateTime fields in a table to store both the date AND the time in the database on update. I am accessing an Access database with DateTime fields using an OLEDB data adapter
When I fill a datatable and view it with a datagrid, only the date appears. However, debugging shows that the time is correctly being retrieved from the database as well. The problem is, when I update to the database, only the date is returned to the database (effectively changing the time to midnight).
How do I get the data adapter to send the full date AND time information
Any help appreciated
Jason