Traversing through Rows in a grid

Peter Dzuya

Hi All,

I wish to sum up all credits that I have already filtered in a grid. I have written this code as shown below:-

DevExpress.XtraGrid.Columns.GridColumn col = View.Columns.ColumnByFieldName("Credit");

if (col == null)return;

View.BeginSort();

try

{

int dataRowCount = View.DataRowCount;

for (int i = 0; i < dataRowCount; i++)

{

object cellValue = View.GetRowCellValue(i, col);

decimal totalcredit = Convert.ToDecimal(cellValue);

barEditItemCredit.EditValue += totalcredit;

}

}finally{

View.EndSort();

}

when I run the program, I get the below exception.

Cannot apply operator "+=" to operands of type 'Object' and 'Decimal'

Please assist.

Thanks

Peter

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta10y ago
Accepted answer
Hi Peter
As per your exception, it seems that you are performing Arithemeric operation between an object and a decimal which is not correct.
To achieve this, you have to convert your object value to decimal first and then perform the operation:
var barValue = Convert.ToDecimal (barEditItemCredit.EditValue)+ totalcredit;
barEditItemCredit.EditValue= barValue;
Regards
Amit
Peter Dzuya10y ago
Thank you so much Amit.
I applied the code and it worked.
Thanks once again.
Peter.