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

sorting in data bound grid

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.

1 Reply

AD Administrator Syncfusion Team 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

Live Chat Icon For mobile
Up arrow icon