Hi folks,
I want to apply a conversion rate (set on the page outside the grid) to every row. For example:
Since ConversionRate doesn't actually appear as a field in the database table (it's value comes from a textbox elsewhere on the same page), what's the best way of getting it incorporated in the calculated column?
Thanks,
Ken
I want to apply a conversion rate (set on the page outside the grid) to every row. For example:
<telerik:GridCalculatedColumn HeaderText="Cnv. Price" UniqueName="ConvertedSoldPrice" DataType="System.Double" DataFields="SoldPrice, ConversionRate" Expression="{0}*{1}" />Since ConversionRate doesn't actually appear as a field in the database table (it's value comes from a textbox elsewhere on the same page), what's the best way of getting it incorporated in the calculated column?
Thanks,
Ken
1 Answer, 1 is accepted
0
Princy
Top achievements
Rank 2
Rank 2
answered on 03 Dec 2010, 01:52 PM
Hello Ken,
I hope you can try an alternate method by using GridTemplateColumn with Label placed inside instead of GridCalculatedColumn. Then from the client side, get reference to the TextBox and get the "
The docuemntation will be helpful in getting the cell value from grid.
Getting cell values for selected rows client side
Dont hesitate to write again if you need any further help.
Regards,
Princy.
I hope you can try an alternate method by using GridTemplateColumn with Label placed inside instead of GridCalculatedColumn. Then from the client side, get reference to the TextBox and get the "
ConversionRate" value. Now iterate through each rows in the grid from and calculate the result based on the cell value, access the Label in templatecolumn using "findElement() method" and set the text.The docuemntation will be helpful in getting the cell value from grid.
Getting cell values for selected rows client side
Dont hesitate to write again if you need any further help.
Regards,
Princy.