hi,
I have a 'TimeSheet' Table in the database that holds data about the time
spent by an employee on each project on a particular
day.
TS_pk Emp_fk Project_fk hrsWorked Date
1 1 10 4
13/02/2006
2 1 20 5
14/02/2006
3 1 30 8
15/02/2006
However, In the Datagridview it should be displayed on a weekly basis,
therefore for each employee, the
datagridview column for the above employee data should be displayed like:
(13/2) (14/2) (15/2)
ProjID Mon Tue wed thur Fri
10 4
20 5
30 8
I had planned to drop this table on datagridview by creating a tableAdapter,
but i am unable to make out if it is possible to convert the 'date'column
as headerValue in the datagridview. Could someone give some ideas please.
Regards,
Irfan
I have a 'TimeSheet' Table in the database that holds data about the time
spent by an employee on each project on a particular
day.
TS_pk Emp_fk Project_fk hrsWorked Date
1 1 10 4
13/02/2006
2 1 20 5
14/02/2006
3 1 30 8
15/02/2006
However, In the Datagridview it should be displayed on a weekly basis,
therefore for each employee, the
datagridview column for the above employee data should be displayed like:
(13/2) (14/2) (15/2)
ProjID Mon Tue wed thur Fri
10 4
20 5
30 8
I had planned to drop this table on datagridview by creating a tableAdapter,
but i am unable to make out if it is possible to convert the 'date'column
as headerValue in the datagridview. Could someone give some ideas please.
Regards,
Irfan