Dates in . net

[Mark]

Hi all

I am using OWC10 in a vb.net web application and I have it all working
fairly well. apart from when I make a graph with a time on the X axis. I
grab the Values for both the X and Y axis from an ODBC data source to an
access database using this sql string:
"SELECT [Readingtime], [Reading] From [tblGraphData] where [TankName] =
'Tank1' ORDER BY [ReadingDate], [Readingtime]"

ReadingTime is a time but it displays as decimal numbers e.g 0.673, 0.674
etc

Is there a way that I can make the chart display my times properly

 

[Mark]

Just realised that i need to tell you a bit more. i load the values into an
array which are declared as follows
dim AX()
dim AY()

i get the values from the database as follows:
aX(i) = DataReader1.GetValue(0)

aY(i) = DataReader1.GetValue(1)

Have also tried

aX(i) = DataReader1.GetTime(0)
aY(i) = DataReader1.GetValue(1)



but to no avail I get this error message when i use getTime: Method's type
signature is not Interop compatible.

 

[Alvin Bruney]

have a look at the numberformat property

Just realised that i need to tell you a bit more. i load the values into an
array which are declared as follows
dim AX()
dim AY()

i get the values from the database as follows:
aX(i) = DataReader1.GetValue(0)

aY(i) = DataReader1.GetValue(1)

Have also tried

aX(i) = DataReader1.GetTime(0)
aY(i) = DataReader1.GetValue(1)



but to no avail I get this error message when i use getTime: Method's type
signature is not Interop compatible.

Hi all

I am using OWC10 in a vb.net web application and I have it all working
fairly well. apart from when I make a graph with a time on the X axis. I
grab the Values for both the X and Y axis from an ODBC data source to an
access database using this sql string:
"SELECT [Readingtime], [Reading] From [tblGraphData] where [TankName] =
'Tank1' ORDER BY [ReadingDate], [Readingtime]"

ReadingTime is a time but it displays as decimal numbers e.g 0.673, 0.674
etc

Is there a way that I can make the chart display my times properly