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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

sorting in data bound grid

Thread ID:





26204 Mar 16,2005 05:18 PM UTC Mar 17,2005 01:02 AM UTC WinForms 1
Tags: GridControl
Randy Furtado
Asked On March 16, 2005 05:18 PM UTC

we have a data bound grid that updates at a high frequency. we have noticed that once you sort one of the columns in the grid everything slows down. we believe this is because all new updates are causing internal sorting on the grid. so as to keep the rows sorted. for our grid of 4000 rows by 40 columns the performance difference is significant. is there a way we can just "static" sort the data bound grid? i.e. sort once and then not have the internal sort run as new updates come in. we will then be forced to sort again but at least our grid update performance will be acceptable.

Administrator [Syncfusion]
Replied On March 17, 2005 01:02 AM UTC

To do this, you have to bypass the default sort behavior of a GridDataBoundGrid. By default, the grid just reflects the data in teh datasource. So, when it gets sorted, the CurrencyManager and its associated DataView reflects teh sort. So, anytime you change a value in teh sorted column, the DataView sorts it to its proper place. So to avoid this autosorting, you have to not use teh default sorting support of teh datasource''s currencymanager and associated dataview. This takes a little effort. Here is an initial try at this. It may take some tweaking to get it to work in your application. It assumes your datatable has a primary key column to facilitate looking items up. http://www.syncfusion.com/Support/user/uploads/GDBGCustomSortingFiltering_69f8cf69.zip


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.

Please sign in to access our forum

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

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

Live Chat Icon For mobile
Live Chat Icon