oleDbDataAdapter problem

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

The command builder for oldDbDataAdapter sets date/time column parameters to
DbDate as the default for Insert and Update commands. Is there anyway to
make Date the default type?

I have date/time fields in all of the tables in my access database. They
must have both the date and time. The DbDate conversion strips the time
from the DateTime parameter. Being lazy I am using the DataAdapter
configuration wizard, which sets the type to DbDate, and then doing a
replace in my code. Anyone have a better way?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Very simple INSERT INTO with a DateTime parameter -> "Syntax Error in INSERT INTO statement" 3
BUG?: DACW generates DBDate parameters instead of DBTimestamp for oledb DA. 1
DBTimeStamp - Data type mismatch in criteria expression 1
DateTime no Time 1
DateTime to OleDbType (MS Access) 1
Am I missing something? 3
DBConcurrencyException when using OleDBTypes DBDate and Double 1
AccesViolationExeption was unhandled within (parallel) foreach loop 2

Back
Top