on Aug 26, 2011
Is it possible to update Radgrid footer sums to show the sum of the values in cells which are in edit mode?
C#, ASP.NET 4, Windows Server 2003
ASP.NET AJAX 2011 Q2
I have created a RadGrid which is built dynamically at runtime. The number of columns and their names are not known until the user has made their parameter selection and submitted their request for data. The whole grid is in Edit mode when loaded (AllowMultiRowEdit=true, EditMode = GridEditMode.InPlace). I am able to retrieve all the values programatically in code-behind for data validation before I commit the changes to my database. I have footers showing the totals of the values in each column when the grid is first generated.
My problem is that I want to update the footer sums based on the edited values in the grid, so that the user sees a real time update of the totals. This is to ensure that the numbers total 100 in each column.
Is this possible? If not, is there any way to trap the Tab event using the client event KeyPress (eg when they use tab or shift-tab to change cells), or the change in cell event when you click in another cell?
Any help or advice gratefully received