<sf:GridDataVisibleColumn HeaderText="Issuer" MappingName="IssuerId" IsReadOnly="False" Width="125" > <sf:GridDataVisibleColumn.HeaderStyle> <sf:GridDataColumnStyle HorizontalAlignment="Center"/> </sf:GridDataVisibleColumn.HeaderStyle> <sf:GridDataVisibleColumn.ColumnStyle> <sf:GridDataColumnStyle CellType="ComboBox" DropDownStyle="AutoComplete"/> </sf:GridDataVisibleColumn.ColumnStyle> </sf:GridDataVisibleColumn>
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)?
Thanks.
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:GridDataVisibleColumn.HeaderStyle> <syncfusion:GridDataColumnStyle HorizontalAlignment="Center"/> </syncfusion:GridDataVisibleColumn.HeaderStyle> <syncfusion:GridDataVisibleColumn.ColumnStyle> <syncfusion:GridDataColumnStyle CellType="ComboBox" DropDownStyle="AutoComplete"/> </syncfusion:GridDataVisibleColumn.ColumnStyle> </syncfusion:GridDataVisibleColumn> |
Please let us know if you need further assistance.
Thank you,
Jai Ganesh S
