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

Sort the data in Grid Control based on Display member.

Thread ID:





108075 Apr 2,2013 04:44 PM UTC Dec 21,2014 05:29 PM UTC WinForms 5
Tags: GridControl
Asked On April 2, 2013 04:44 PM UTC

In my Grid i have a Combobox control in one column and it has some display member with 
OneNumber - Name (For e.x in my case VendorNumber - Vendor Name).
Now when i tried to sort on the column i have assigned the property of "sort" option with display member of the column. 
Could you help me in sorting the column with an another option other than 
"Display member and Value member".?

Ragamathulla B [Syncfusion]
Replied On April 5, 2013 06:32 AM UTC

Hi Saikrishna,

Thank you for your interest in Syncfusion products.

Please refer to the following dashboard sample path which is helpful for your reference. In our grid control have not inbuilt support for sort but we have achieved by manually.

Grid Control:

{Installed path}\Syncfusion\EssentialStudio\{Version}\Windows\Grid.Windows\Samples\2.0\Grid Layout\Sorting Demo\CS


{Installed path}\Syncfusion\EssentialStudio\{Version}\Windows\Grid.Grouping.Windows\Samples\2.0\Filters and Expressions\Filter By DisplayMember Demo\CS

Let me know if you have any further concerns.


Ragamathullah B.

Replied On April 10, 2013 01:32 AM UTC

I found that I have to use currency manager to sort the column based on Display member. It will work only if the display member should also be a column in the gridDataBoundGrid control. (i.e it should get in the dataview from the currency manager list property).
In my case there are nearly 20-25 combo boxes are there in my grid. Now to sort on those columns I should manually add those 20-25 columns to the grid unnecessarily to sort based on the respective column.
Please let me know is there any possibility to get the both display member and value members in the dataview of the gridDataBoundGrid  control from the currency manager.
Or let me know another approach to sort the column without adding another column with display member of each column separately.

Athiram S [Syncfusion]
Replied On April 15, 2013 09:02 AM UTC

Hi SaiKrishna,

Sorry for the delay in getting back to you.

You can achieve the sorting by using display member from the sample:

<Installed Location of EssentialStudio>\<Installed version>\Windows\GridDataBound.Windows\Samples\2.0\Sorting\Sort By DisplayMember Demo\

Please let me know if you have any concerns.

Athiram S

Muthukumar Kalyanasundaram [Syncfusion]
Replied On December 21, 2014 05:29 PM UTC

Hi Sergii,


Thanks for the update.


If you want to set the Excel filter in a grid, you can use the GridExcelFilter class and wire the grid. Please refer the below code,



private GridExcelFilter filter;

// form load

filter = new GridExcelFilter();

this.gridGroupingControl1.TopLevelGroupOptions.ShowFilterBar = true;

for (int i = 0; i < gridGroupingControl1.TableDescriptor.Columns.Count; i++)


gridGroupingControl1.TableDescriptor.Columns[i].AllowFilter = true;




Please let us know if you have any concern.



Muthukumar K


Attachment: MyExcelFilter_de4e4c19.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