calculated column in gridview

[parshupooja]

Hi All,

I have gridview with following columns
date--morningin--morningout--afetrnoonin--afetrnoonout

I want to create another 6th coulmn which shd display total hours(morningout-morningin)+(afternoonout-afetrnoonin)

Can anyone help me with this?
I am fed up of trying.

thanks

[Plater]

This is a webapplication?
Are you going to do it in the SQL statement or afterwards in just the gridview?

[parshupooja]

Yes it is a webapplication and gridview date is coming from store procedure of SQL Server . Also this is built in asp.net C#
thanks

[Plater]

I ment were you planning on changing your SQL statement to have the computed column included in the query, or were you going to do it in code?

If those columns represent valid dates, create DateTime objects from them and then do the math that way. They will produce TimeSpan objects that you can use to determine total number of hours.

[parshupooja]

Sorry abt that. I want to calculate in code of asp.net not in SQL .

I ment were you planning on changing your SQL statement to have the computed column included in the query, or were you going to do it in code?

If those columns represent valid dates, create DateTime objects from them and then do the math that way. They will produce TimeSpan objects that you can use to determine total number of hours.

[Plater]

Sorry abt that. I want to calculate in code of asp.net not in SQL .

ok, so do the DateTime thing, should be pretty easy

[parshupooja]

How shd i do math? can u show a little snippet

date morning in morningout afternoon in afternoonout

09/17/2007 9 am 11pm 1pm 5pm

ok, so do the DateTime thing, should be pretty easy

[Plater]

Well you can either do math on just the numbers.
(I assume that should be 11am and not 11pm?)
9am=9
11am=11
1pm=13
5pm=17

11-9=2
17-13=4
4+2=6


OR you can try and create a DateTime object for each one
Like for example:

//this might not work, you might have to get crafty-er with your creation
DateTime mi=DateTime.Parse(data.ToString()+" "+morningin.ToString());
DateTime mo=DateTime.Parse(data.ToString()+" "+morningout.ToString());
TimeSpan tm= mo-mi;
//now "tm" contains the amount of time between the two times.
 

Creating DateTime objects successfully would allow you to do partial hour amounts much easier then just creating integers numbers out of them.