DATA ADAPTER PROBLEM

[Guest]

I created a query with an odbcdataadapter to a linked table in a Microsoft
Access Database.
When I view the data, everything appears fine except one field is being
displayed as a date where it should be a time. I double checked the field
definitions in Access and everything looks good.
I changed the schema in the dataset from Datetime to time but it still
doesn't work.

Any help would be appreciated.
I would like to point out I have only recently upgraded to vb.net from
Visual Basic 4.0 so this new data access stuff is really new (and confusing)
to me.

 

[Ken Tucker [MVP]]

Hi,

How are you displaying the data?

Ken
----------------
I created a query with an odbcdataadapter to a linked table in a Microsoft
Access Database.
When I view the data, everything appears fine except one field is being
displayed as a date where it should be a time. I double checked the field
definitions in Access and everything looks good.
I changed the schema in the dataset from Datetime to time but it still
doesn't work.

Any help would be appreciated.
I would like to point out I have only recently upgraded to vb.net from
Visual Basic 4.0 so this new data access stuff is really new (and confusing)
to me.

 

[Guest]

I am using the datagrid control. But I've also previewed the data in design
mode (via the data adapter property) and it looks the same.

Instead of saying 11:59:34 PM, it says 12/30/1899.