Texbox value inside Pivotgrid

2 posts, 0 answers
  1. Pradeep
    Pradeep avatar
    3 posts
    Member since:
    Mar 2014

    Posted 13 Apr 2016 Link to this post


    I have a RadPivotGrid which has Item as RowField, Location as ColumnField and Quantity as Aggregate Field. The Aggregate field is a textbox. The user will change the values in the textboxes and clicks on the "Update" button. Now on the Update button click, I have to get the values from all the textboxes and update them with the values in database. Can you please help how to read the values in the textboxes?




  2. Vasil
    Vasil avatar
    1642 posts

    Posted 13 Apr 2016 Link to this post

    Hello Pradeep,

    The PivotGrid does not supports editing. In your example you may have 2 records:
    {Item: Car, Location: US}
    {Item: Car, Location: US}
    The Aggregate (Quantity) will show 2 (since there are 2 cars in US).
    Editing the aggregate in this example would mean that you need to insert or delete records from the other tables. Which is not simply updating a number in your database.

    In order to edit the data, you need to bind specific tables into control that supports editing, for example RadGrid.

    I will try to write a simplified example here. Lets have some numbers
    a = 1, b = 2, c = 5, d = 3
    And formula like X = a+b+c+d.
    The X is aggregate with SUM function. Thus X = 11
    We want to edit X to become 10, but this can be achieved in various of ways.
    a = 0, b = 2, c = 5, d = 3
    a = 1, b = 1, c = 0, d = 8
    So in practice you want to edit the numbers directly, not the aggregates.

    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top