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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to use virtualization, on-demand data displaying and read datasource by pages (instead of cell by cell) in GridControl or GridDataControl?

Thread ID:

Created:

Updated:

Platform:

Replies:

118009 Jan 20,2015 05:36 PM UTC Jan 23,2015 02:25 PM UTC WPF 1
loading
Tags: GridDataControl
Luis Jimenez
Asked On January 20, 2015 05:36 PM UTC

Hi, I'm working on a WPF application that has the following requirements:
1. It's a grid.
2. Data source has a lot of data.
3. Data needs to be displayed virtualized (virtual grid, displaying data on demand).
4. The first time the app is loaded, it will display only 25 rows, 6 columns
5. After user scrolls down, new data needs to be obtained from datas source, and presented to the user.

I explored the GridDataControl, but the only option I found for displaying data on demand is by using paging, and what I need is to use a scrollbar.

I explored the GridControl, but the problem of virtualization (using querycellinfo) is that the data is read from the data source cell by cell (25 x 6 = 150 reads), and I need to perform just 1 read to bring all data (the function for read accepts a parameter indicating how many bytes you want to read, it could be 150 in this case), and then present it to the user.

I noticed that the version of GridControl for Windows Forms has two methods: gridControl1.QueryColCount and gridControl1.QueryRowCount that could help on this, but they are not available in WPF.

What is the recommended way to implement these requirements, and what control to use (GridControl or GridDataControl)?

Thanks,

-Luis

Jayapradha S [Syncfusion]
Replied On January 23, 2015 02:25 PM UTC

Hi Luis,

Thank you for using Syncfusion products.

We have analyzed your query and currently GridControl, GridDataControl does not have the support to load the data on demand.

We have a SfDataGrid control like GridDataControl. But when compared to GridDataControl, SfDataGrid has a better performance and flexibility. In SfDataGrid, you can use IncrementalLoading to achieve your requirement. SfDataGrid assists you to create entirely customizable and highly interactive features used to display and manipulate the huge amount of data. So, we suggest you to use SfDataGrid instead of GridDataControl.

Please refer the following UG link for SfDataGrid.

UG Links: http://help.syncfusion.com/ug/wpf/default.htm#!documents/choosebetweendiffere.htm

http://help.syncfusion.com/ug/wpf/default.htm#!documents/overview6.htm

By using IncrementalLoading in SfDataGrid, you can achieve your requirement.

Please find the below UG Link to know more about the Incremental Loading.

UG Link: http://help.syncfusion.com/ug/wpf/default.htm#!documents/incrementalloading.htm

Please let us know if you require further assistance on this.

Thanks,

Jayapradha S



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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

;