Visual Studio - converting time from a query to listview

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

converting time from a query to listview

2004-05-31, 4:39 pm

Hi,

I'm trying to conert a program from VB6 to VB.net
In a listview a want a time calculated by this code
qrytext1 = "SELECT Sum(Tijd) AS tijdsom FROM Data ;"
QT1 = DB.OpenRecordset(QryText1)
ts = (QT1.Fields("tijdsom").Value)
SubItem = XItem.SubItems.Add(Format(ts, "HH:mm:ss") )

All I get in the listview is HH:mm:ss
I have definded the varible ts as double, dateformat, dateandtime and
without a type.
by dateformat i always get 0

thanks Jan

--
Met vriendelijke groeten.
Jan

Sponsored Links