Rank: Member
Groups: Member
Joined: 6/1/2011
Posts: 18
|
I have a grid control that some of the columns display data from a SQL query/view. Some of the other columns are calculated values, so I need to use the existing values in certain cells, perform a calculation, then display the result in another cell on the same row.
For example, I have 6 columns with data in column 4 & 6. I need to divide the value in column 4 by value in column 6, then display it in column 5.
After the grid has been filled with data, how do I step through each row, perform the calculation, then display the result in another cell?
|
Rank: Administration
Groups: Administration
Joined: 5/27/2007
Posts: 24,194
|
Hi,
You can either do the calculation on your data source, or just modify the corresponding GridCell's Value property through code.
Thanks
|