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

Using Filters with Comboboxes

I have a GridDataVisibleColumn with the MappingName="IssuerId".
<sf:GridDataVisibleColumn HeaderText="Issuer" MappingName="IssuerId" IsReadOnly="False" Width="125" >
         <sf:GridDataColumnStyle HorizontalAlignment="Center"/>
         <sf:GridDataColumnStyle CellType="ComboBox" DropDownStyle="AutoComplete"/>
In Code Behind I hook up the ItemsSource to my View Model list; DisplayMember, & ValueMember.
 this.grdImportBlotter.VisibleColumns["IssuerId"].ColumnStyle.ItemsSource = this.vm.Issuers;
 this.grdImportBlotter.VisibleColumns["IssuerId"].ColumnStyle.DisplayMember = "DealName";
 this.grdImportBlotter.VisibleColumns["IssuerId"].ColumnStyle.ValueMember = "DealId";
When I try to filter this column, the list that the user can filter on is a list of, what appears to be the ValueMember, rather than the DisplayMember.
How can I get the filter control to show the Name (DisplayMember) rather than the ValueMember (which is a Guid)?

1 Reply

JG Jai Ganesh S Syncfusion Team May 16, 2014 11:32 AM UTC

Hi Andrew,


We are sorry for the delay.


We have analyzed your query. You can get the filter control based on DisplayMember by setting the “CanFormatExcelLikeFilterText “API as true in the GridDataVisibleColumn. Please find the code snippet to illustrate this,


Code Snippet [XAML]:


<syncfusion:GridDataVisibleColumn HeaderText="Issuer" CanFormatExcelLikeFilterText="True" MappingName="IssuerId" IsReadOnly="False" Width="125" >



           <syncfusion:GridDataColumnStyle HorizontalAlignment="Center"/>




           <syncfusion:GridDataColumnStyle CellType="ComboBox" DropDownStyle="AutoComplete"/>





Please let us know if you need further assistance.


Thank you,

Jai Ganesh S

Live Chat Icon For mobile
Up arrow icon