Home / Software / Computer programming / Visual studio data formats
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] - (Bottom) Print
Author Topic: Visual studio data formats  (Read 1426 times)
JonnyMX
Guest
« on: August 31, 2004, 05:02:17 AM »

Can anyone offer any advice?
I am building a Windows application using VB.NET in Visual Studio. A MS Access database is represented in a datagrid. One of the columns in the database table is a time, with the format of short time, which works fine in Access. However, when I fill the datagrid the time is shown as a date despite the fact that the dataset schema is also set to time for this column.
In addition, the datagrid rearranges all the columns into alphabetical order.
It's doing my head in!
IP logged
Joleen
Guest
« Reply #1 on: August 31, 2004, 09:30:02 AM »

The time could probably just be a format issue.
IP logged
JonnyMX
Guest
« Reply #2 on: August 31, 2004, 10:21:11 AM »

It is a format issue, that's kind of the point.
I don't see what is converting the format to a date when it's set up to be a time at each end!
It isn't even a valid date, such as the default. It is usually 13/11/1788 or some such.
Help...
IP logged
Joleen
Guest
« Reply #3 on: August 31, 2004, 10:57:27 AM »

I guess I was trying to point out that you could use the Format() and make it a time type.

Can you post the piece of code that you're dealing with?
« Last Edit: August 31, 2004, 10:58:10 AM by Joleen » IP logged
Pages: [1] - (Top) Print 
Home / Software / Computer programming / Visual studio data formats « previous next »
 


Login with username, password and session length

Old Forum Search | Forum Rules
Copyright © 2010 Computer Hope ® All rights reserved.
Powered by SMF 2.0 RC3 | SMF © 2006–2010, Simple Machines LLC
Page created in 0.089 seconds with 18 queries.