We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to implement the virtual grid that allows the user to change the values?

Platform: WinForms |
Control: GridControl |
Published Date: April 30, 2011 |
Last Revised Date: April 20, 2015

Description

In the virtual grid, the data is loaded to the cells by using the QueryCellInfo event. It is not possible to save the values because the event is recursively called and it gets the data from the underlying source only that is the value entered in the cell is not registered in the source. So, the old value is maintained in the Grid. To make the Grid accept the changes, you can use the SaveCellInfo event handler.

Solution

In addition of handling the QueryStyleInfo, QueryRowCount and QueryColCount, you have to handle the SaveCellInfo event. In your handler, you must save the changes back to your external data source. The following code examples implement a virtual grid that allows you to change the data.

C#

 

VB

 

Figure 1: Virtual grid with changed cells

Note:

In addition, to move rows and columns, your SaveCellInfo handler accepts changes in row or column order when the data is stored. This adds an additional layer of complexity to the data management.

Sample Link:

http://www.syncfusion.com/downloads/support/directtrac/general/SaveCellInfoSample1944702654.zip

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon