By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,369 Members | 966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,369 IT Pros & Developers. It's quick & easy.

Date/Time info and ADO.NET

P: n/a
I have a database (Jet or Access) that has a Date field in it,
WhenModified. This is mapped to a DataTable in ADO.NET using the data
wizzard for command statements.

When I store a DateTime value in the datatable, and then save that
update to the JET database, I only get the date information stored
and the time is lost. Also it seems that if I manually enter a
DateTime directly in the database it is stored correctly, but the
time is lost when sent to the ADO.NET dataTable.

Thus, I beleive there is some problem in the way the wizzard created
the select and update statements. Has anyone else run into this
issue? Is there a straightforward way to fix this. Right now I am
thinking I have to convert all DateTime values to strings with
something like:

UpdatedAsOf = Now.ToString("s")

Suggestions would be greatly appreciated.

Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.