This is a migrated thread and some comments may be shown as answers.

Creating a calculated field in grid

1 Answer 90 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Venkatesh asked on 03 Dec 2012, 12:25 PM

Hi,
I have 3 columns available as below:

<telerik:GridTemplateColumn DataField="OrderQuantity" HeaderText="Order Quantity" UniqueName="OrderQuantity" Visible="true">

<InsertItemTemplate>

<telerik:RadTextBox ID="RadtxtOrderQuantity" runat="server" Text='<%# Bind("OrderQuantity") %>' >

</telerik:RadTextBox>

</InsertItemTemplate>

<EditItemTemplate>

<telerik:RadTextBox ID="RadtxtOrderQuantity" runat="server" Text='<%# Eval("OrderQuantity") %>' >

</telerik:RadTextBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="UnitPrice" HeaderText="Unit Price" UniqueName="UnitPrice" Visible="true">

<InsertItemTemplate>

<telerik:RadTextBox ID="RadtxtUnitPrice" runat="server" Text='<%# Bind("UnitPrice") %>' >

</telerik:RadTextBox>

</InsertItemTemplate>

<EditItemTemplate>

<telerik:RadTextBox ID="RadtxtUnitPrice" runat="server" Text='<%# Eval("UnitPrice") %>' >

</telerik:RadTextBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridNumericColumn DataField="FinalPrice" HeaderText="Final Price" UniqueName="FinalPrice">

</telerik:GridNumericColumn>

The FinalPrice column should be a calculated field(unitprice * order quantity) and be automatically populated. This calculation should be available in insert and update options.
How to achieve this?
Thanks

Creating a calculated field in grid

1 Answer, 1 is accepted