Loop through Grid to calculate sum of a column in MVC Grid

248

Amit Govil posted over 12 years ago

I am working on MVC Razor. And i have a hierarchical-grid in a view which has few editable columns.

Also, there are radio buttons, and on click of those buttons following operations are perforemed:

Sum a columns values (numeric type) is shown in a control(label).
For each row, value of 1 column is copied to another column.

And for above operations, i want to write a jquery method for above tasks. Although, got through few posts but can't find, how to loop through all rows of grid and how to access cell value.

Thanks

19693

[Infragistics] Tsvetelina Georgieva posted over 12 years ago

Heloo Amit,

Thank you for posting in our forums.

You can use "allRows" method to get all rows of the current grid instance.

http://help.infragistics.com/jQuery/2012.1/ui.iggrid_hg#methods

You should iterate through the rows and access the cell value using "getCellValue" method

I recommend you using the summary feature for the "Sum" requirement

http://ko.infragistics.com/products/jquery/sample/grid/column-summaries-basic-options

Since v12.2 there will be Unbound Column in igGrid so you can take advantage of this for the "value of 1 column is copied to another column" requirement.

Hope this helps.
Cancel
Reply

Cancel