Converting Time from a query to listview

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JR - 31 May 2004 20:35 GMT

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

Reply to this Message

Rick Rothstein - 01 Jun 2004 00:52 GMT

Almost everybody in this newsgroup is using VB6 or lower. While you may
get a stray answer to VB.NET questions here, you should ask them in
newsgroups devoted exclusively to .NET programming. Look for newsgroups
with either the word "dotnet" or "vsnet" in their name.

For the microsoft news server, try these newsgroups...

microsoft.public.dotnet.general
microsoft.public.dotnet.languages.vb
microsoft.public.vsnet.general

There are some others, but these should get you started.

Rick - MVP

> Hi,
>
[quoted text clipped - 11 lines]
>
> thanks Jan

Reply to this Message

VB Forum / General 2 / May 2004

Converting Time from a query to listview