A better date/time value into a database?

  • Thread starter Thread starter Schorschi
  • Start date Start date
S

Schorschi

Is there a better way to get the date/time from VB .NET into an Access
MDB than
"#" & Now & "#"?

I have a standard date/time field in a table in a MDB file. And the
'#' trick works, but seems rather hoaky.
 
Schorschi said:
Is there a better way to get the date/time from VB .NET into an
Access MDB than
"#" & Now & "#"?

I have a standard date/time field in a table in a MDB file. And
the '#' trick works, but seems rather hoaky.
Click to expand...

Use Parameters with the Command object. See documentation of OleDbParameter
class and the OleDBCommand.Parameters property and the topics that give
examples of how to use them.
 
You must log in or register to reply here.

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

Importing Text Files Into Access 1
Access Access - Is it possible to repeat fields in a form? 1
How to create a checkbox datatype column in a table in VB .net code 9
date/time elapsed event 7
CSV file as database 12
Create MDB, create Table in it and import a DBF 6
Retrieve date from database 2
creating a database 1

Back
Top