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

change values in radgrid field according to changes in another field

19 Answers 940 Views

Grid

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

19 Answers, 1 is accepted

answered on 09 Jun 2009, 01:58 PM

gridclienttotals.zip

Hello lekha,

I have created a sample project you can test to see how RadGrid's and RadInput's client-side APIs work together to achieve this scenario.

We use RadGrid's client-side OnGridCreated event to find each textbox in each field, retrieve their values and calculate totals. An interesting thing to note is that, as we use RadNumericTextBox for better numeric formatting and presentation, we need to set its value through the client API's set_value() method. Otherwise, RadInput's value cannot be properly set.

Additionally, we use RadNumericTextBox's OnBlur client event to recalculate the totals after each multiplier textbox is blurred.

Regards,
Veli
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 18 Jun 2009, 05:07 AM

I have one more doubt relating this topic...Here I am editing grid template fields at client side..And at the time I want to delete one row at client side.I deleted that row and rebind the sessiondatatable to the radgrid... using the code below,....
The problem is after rebinding edited datas are cleared..... i have to persist the edited datas to the sessiondatatable.........Please share suggessions..

protected void RadGrid_DeleteCommand(object source, GridCommandEventArgs e)
{
cSessionHandler.dtRequestDetails.Rows.RemoveAt(Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["SlNo"]));
}

lekha

answered on 13 Jan 2012, 04:08 PM

hi everybody i have a similar case i have to multiply 2 columns for give me a total price, i only retrieve 2 field of my data base code and product name, and i created 3 field in the radgrid : units, price and total, this field i can edit so i need a textbox in my grid, but what i have to do for refresh values in the radgrid for a new multiply with my new values in units, price and totals, by the moment i am using:

<telerik:GridCalculatedColumn HeaderText="Valor Total" UniqueName="TotalPrice" DataType="System.Double"
DataFields="unit, price" Expression="{0}*{1}" FooterText="Total : "
Aggregate="Sum" />

for calculate the total.
and i was trying solution here with BusinessObjectCollection but i don know how to work i am new programming on asp.net and teleriks controls but i hope anybody can help me

answered on 20 Jan 2012, 12:40 AM

Hi again, i have a little question more

i am trying to save some field of my radgrid, but i have had problems with
this is my code:

Private Function retaceo_detalle(ByRef idretaceo As Integer) As Boolean
        Dim cmd As New SqlCommand
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "sp_s_ingresoretaceo"
        cmd.Connection = Conn
        Conn.Open()

        For Each dataItem As GridDataItem In RadGrid1.Items
            Try
                Dim txt1 As RadNumericTextBox = DirectCast(dataItem("Quantity").FindControl("unidadesTextBox"), RadNumericTextBox)
                Dim txt2 As RadNumericTextBox = DirectCast(dataItem("Price").FindControl("ValorUnitarioTextBox"), RadNumericTextBox)
                RadTextBox7.Text = txt1.Text
                RadTextBox8.Text = txt2.Text

                cmd.Parameters.Add("@factura", SqlDbType.Int).Value = RadTextBox9.Text
                cmd.Parameters.Add("@matprim", SqlDbType.Text).Value = dataItem("COD_MATPRIMA").Text
           --> cmd.Parameters.Add("@cantidad", SqlDbType.Decimal).Value = RadTextBox7.Text
     --> cmd.Parameters.Add("@vunitario", SqlDbType.Money).Value = RadTextBox8.Text
                cmd.Parameters.Add("@codigo", SqlDbType.Int).Value = CType(id_retaceo, Integer)
                cmd.ExecuteNonQuery()
                cmd.Parameters.Clear()

            Catch ex As Exception
            End Try
        Next
        cmd.Connection.Close()
    End Function
so its save all information but the information that i trying to get of my radgrid does not work, the value return is "" or 0 in the case that put a default value of 0 in the radnumeric properties but when i change this value, not show me the value changed... always 0 or ""

this is a piece of my aspx:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"
                Width="1300px" GridLines="None" Skin="Sunset">
                <MasterTableView ShowFooter="true">
                    <Columns>
                        <telerik:GridBoundColumn DataField="COD_MATPRIMA" HeaderText="CODIGO">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="NOMMATPRI" HeaderText="NOMBRE">
                        </telerik:GridBoundColumn>

                        <telerik:GridTemplateColumn UniqueName="Quantity" HeaderText="UNIDADES">
                            <ItemTemplate>
                                <telerik:RadNumericTextBox DataType="System.Decimal" Value="0" ID="unidadesTextBox" runat="server" Width="75">
                                    <NumberFormat   />
                                    <ClientEvents OnBlur="recalculate" />
                                </telerik:RadNumericTextBox>
                            </ItemTemplate>

                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn UniqueName="Price" HeaderText="VALOR UNITARIO">
                            <ItemTemplate>
                                <telerik:RadNumericTextBox DataType="System.Decimal" ID="ValorUnitarioTextBox" Value="0" runat="server" Width="75">
                                    <NumberFormat DecimalDigits="2" />
                                    <ClientEvents OnBlur="recalculate" />
                                </telerik:RadNumericTextBox>
                            </ItemTemplate>
                            <FooterTemplate>
                                Total:
                            </FooterTemplate>
                        </telerik:GridTemplateColumn>
.
.
.
.
.