Dynamic Calculated Column

[MAH]

Good morning

I have a requirement to calculate dynamically the difference between two times. I am currently facing a problem using RadGrid when I had implemented the requirement using RadDateTimePicker inside the RadGrid.

I want to calculate overtime hours dynamically in edit mode when the user changed [From] or [To] fields which are in type RadDateTimePicker, and the column which needs to calculated is TimeSpan. It works properly in read only mode, but i want to calculate it in edit mode too.

Is there any idea or method to solve this problem?

Thanks in advance

[Antonio Stoilkov]

Hi Munner,

You could implement the desired functionality by subscribing to RadDateTimePicker OnSelectedDateChanged or ClientEvents-OnDateSelected depending if you need server-side or client-side implementation. Note that the RadDateTimePicker controls should be created in GridTemplateColumn so you could easily assign the events. In the event handler do your calculation and set the appropriate control values.

Additionally, you could go through the help article below for more information on how to access controls server-side in case you decide to implement it using server-side logic.

• Accessing Cells and Rows

All the best,
Antonio Stoilkov
the Telerik team

[MAH]

Thanks alot !!