Calculating time

[Philip Townsend]

I need to add together some times that are stored in a database as
seperate int values. Here is a code segment that is flawed (ts is
declared as: TimeSpan ts=new TimeSpan(0,0,0). As is, the value of ts
remains at 0:00:00. Can anybody help with this?

h=dr.GetInt32(dr.GetOrdinal("hours"));
m=dr.GetInt32(dr.GetOrdinal("minutes"));
s=dr.GetInt32(dr.GetOrdinal("seconds"));
TimeSpan tempTS=new TimeSpan(h,m,s);
ts.Add(tempTS);

thnx!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Branimir Giurov]

So you have an initial time, to which you need to add another value - am I
getting it right?

--
Branimir Giurov
MCSD.NET, MCDBA, MCT
eAgility LLC
"Philip Townsend" <pt*******@v1tech.com> wrote in message
news:Oy*************@tk2msftngp13.phx.gbl...

I need to add together some times that are stored in a database as
seperate int values. Here is a code segment that is flawed (ts is
declared as: TimeSpan ts=new TimeSpan(0,0,0). As is, the value of ts
remains at 0:00:00. Can anybody help with this?

h=dr.GetInt32(dr.GetOrdinal("hours"));
m=dr.GetInt32(dr.GetOrdinal("minutes"));
s=dr.GetInt32(dr.GetOrdinal("seconds"));
TimeSpan tempTS=new TimeSpan(h,m,s);
ts.Add(tempTS);

thnx!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bruno Jouhier [MVP]]

ts.Add does not modify the TimeStamp (TimeStamps are immutable), it returns
a new TimeStamp. So, you have to write:

ts = ts.Add(tempTS);

Bruno
"Philip Townsend" <pt*******@v1tech.com> a écrit dans le message de
news:Oy*************@tk2msftngp13.phx.gbl...

I need to add together some times that are stored in a database as
seperate int values. Here is a code segment that is flawed (ts is
declared as: TimeSpan ts=new TimeSpan(0,0,0). As is, the value of ts
remains at 0:00:00. Can anybody help with this?

h=dr.GetInt32(dr.GetOrdinal("hours"));
m=dr.GetInt32(dr.GetOrdinal("minutes"));
s=dr.GetInt32(dr.GetOrdinal("seconds"));
TimeSpan tempTS=new TimeSpan(h,m,s);
ts.Add(tempTS);

thnx!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!