Grid View was filled with the old values again, so in my Grid.
When I Filter the data using dropdown selected Index Changed event the gridview shall load data based on what is searched.
Time Entry Duration Hours FROM dbo.aspnet_starterkits_Time Entry TE inner join dbo.aspnet_starterkits_Project Categories CAT on TE. Category ID inner join dbo.aspnet_starterkits_Projects P on CAT. Time Entry User ID=(SELECT User Id FROM dbo.aspnet_Users WHERE User [email protected] Name)) Source pivot (max(Hours)for DOW in (,,,,,,) ) as pvt" Old Values Parameter Format String="original_" Use the Old Values property (dictionary) to access the original values of the fields in the row to update.
Time Entry Date between dateadd(dd, -6, @Week Ending) and @Week Ending) AND TE.
I need to do the updating operation on what row is clicked.