I am showing financial securities data in a gridgroupingcontrol. I would like to add a column of realtime data (prices coming in from an outside feed). I may want to check for updates every 5 seconds, and update those values that have changed.
Can you recommmend an approach for this? Should I directly update the cells that have changed, or update the underlying datatable?
I may be showing up to 10,000 rows and 40 columns, with 3 levels of grouping. I would like to make the updates transparent to the users.
ADAdministrator Syncfusion Team March 3, 2005 01:58 PM
You should probably update the underlying DataTable. The grouping grid will automatically respond to these changes and update any groups/summaries that are affected by the changes.
You could cache the changes in a 2nd dataset and then do a dataset.Merge to move the changes into teh grid''s datasource every so often.
ADAdministrator Syncfusion Team March 3, 2005 03:06 PM
Thanks for the info.
Should I wrap the changes to the table in a BeginUpdate/(update table)/EndUpdate/Refresh code block? Or just update the table and let the grid handle the rest?
ADAdministrator Syncfusion Team March 3, 2005 04:45 PM
I have also noticed that the groupings do not update (they remain how they were originally grouped, even if that underlying column changes.
ADAdministrator Syncfusion Team March 3, 2005 07:07 PM
If the data being updated is randomly distributed, I would just let the grid handle it.
If the updated data is in large contiguous blocks, you might be able to get a little better performance using BeginUpdate/EndUpdate.