cannot update gridview with calculated column
Posted on 2009-07-10
ive got a table with these columns
ID,jobid,description,StartTIme and EndTime.
Then I created a stored procedure to return these fields + a calculated column to display the difference in hours from the StartTime and EndTime columns. This column is called TotalHrs.
In my objectdatasource, in the select list, i ve choosen this stored procedure. And in the UPDATE list i selected a stored procedure, that i created, to update those fields ( In the update procedure doesnt appear the column TotalHrs)
Now, the grid it is showing me the correct data with the difference in hours but when i try to update the record it says.( In this grid I added a template field to show the total hours bound to the stored procedure field TotalHrs)
"ObjectDataSource 'ods_timesheet' could not find a non-generic method 'spUpdateTimeSheet' that has parameters: JobID, Description, StartTime, EndTime, original_ID, totalhrs"
If i remove the template field 'TotalHrs' it updates fine.