Access + datagrid

[eric86]

I'm using oleDataAdapter to import data from a access file. The table includes some fields with datatype text and 2 with datatype date/time

The field with text datatype will be displayed correctly in the datagrid, but the data with date/time will only display the date, not the time in the datagrid

Example

TABLE in Access
ID | Employee_NAME (as string) | Start (as date/time)
1 John 2006-06-06 15:40

Will display the following data in Datagrid

DATAGRID
ID | Employee_NAME | Start
1 John 2006-06-06

What is the problem?

 

[fpineda101]

In your select that loads the datagrid (via dataset), you need to format the date.

SELECT col1, col2, col3, format(dateCol, "MM/dd/yyyy hh:mm:ss") FROM your_table