Data calculation with filtered data from gridview

[Philip]

Hello ,

I have a gridview where I 'm using the filtered tools  in runtime.Now I would like to make some calculations (fe sum, averages) with this filtered data.
For example when I click on a seperate button, I should get the sum of a certain column of this filtered grid in a textblock. How should I deal with this ?
Kind regards,

Philip

[Rossen Hristov]

Hi Philip,

RadGridView.Items contains the collection of items that represents the current view, i.e. the items left after filtering. Since you want to make external calculations over these items, you could use the handy Enumerable extension methods. 

For example, if your grid is bound to a collection of <Employee>, then you could sum their salaries like this:

var sumOfSalaries = this.radGridView.Items.Cast<Employee>().Sum(emp=>emp.Salary);

You can of course use any of the other extension methods and write more complex lambda's than the one I have here.

I hope this helps.

Best wishes,
Ross
the Telerik team