UPDATING PIVOT GRID IN REALTIME

Question

hi ,

i am a new user of syncfusion, and i am using this for the first time.

i have a pivot grid contrrol on my form

i want to bind this grid to a table in my mysql database or a datatable .

my question is that iff i update the values of the datatable it should reflect in the grid in realtime

ie: the changing values should be visible in the grid in runtime

ANY HELP WOULD BE MUCH APPRICIATED

THANKS AND REGARDS

NISSIM ANAND

Sabaridass Ramamoorthy · Answer

Hi Nissim,  
  
Thank you for contacting Syncfusion Support.  
  
PivotGrid control has an updating feature which helps us to perform real time updates in our application. We can display the values which are updated in data source at runtime and this feature can be achieved by setting the “EnableUpdating” property is true. While updating the PivotGrid control, you can throttle it’s updating speed which can be set through the ThrottleUpdateRate property.   
  
Please find our working sample from the following location.  
http://www.syncfusion.com/downloads/support/directtrac/207506/ze/Updating-388532284   
  
Also, please refer to the following UG documentation link which helps you to know about our updating feature.  
https://help.syncfusion.com/windowsforms/pivotgrid/editing-and-updating-value-and-total-cells-in-the-pivotgrid-control   
  
Regards,  
Sabaridass R