gridview problem

[sagarika123]

I have a timesheet table as follows in sql server 2005:

Emp_id Login_time Logout_time Total_hrs
1002 10:00 08:00 10
1002 11:00 08:00 9
1002 09:30 07:00 9.30
1003 09:00 06:00 9
1003 10:00 08:00 10
I want to display it in the gridview as follows:
Day1 Day2 Day3........... .....
Emp_id Login Logout WH Login Logout WH Login Logout WH........
1002 10:00 08:00 10 11:00 08:00 09 09:30 07:00 9.30
1003 09:00 06:00 09 10:00 08:00 10


Can anyone provide me the solution for this.

Thanking You
Sagarika

[MrMancunian]

So you want us to write the complete code for you? You think we've got too much time or something? Come back if you have given this a try yourself and run into problems, then we can talk. In that case, don't forget to mention a bit more details, like the language, relevant code and error messages.

Steven