Complex Gridview Edit

Question

I have a gridview that displays data in a crosstab format. The hours for each day are displayed. Each day is actually a separate row in the underlying table, so a row in the grid represents seven underlying tables.

WeekEnding(sat)  Project  Category   Sun  Mon  Tues  Wed  Thur  Fri  Sat

8/14/2010        Proj1    testing         1    2     2    3     2

I want to write custom code to update each day. I have to caclulate the date based on weekending date and day ( ex fri date == Weekending - 1 day) and make 7 different update statements - one for each day in the row.

Where can I do this? Would I use the Gridview ItemUpdating event(edit: I meant RowUpdating event)?

======================

I need to add code when they click the "Update" button but not sure what event that is.

Currently when they click edit i have a textbox that appears for each days hours

Answer 1

Use the RowDataBound since you aleady have all the information you need to do this, inside this event you can get the complete object information that is bound and use the findControl to update the columns