I have a screen that contains a RadGrid where I set the GroupSetting CaseSensitive = false, and I allow filter b column. This woks for all my columns except for a column I have set with a filter template that contains a RadComboBox. When I select from the combo nothing gets returned. When I run SQL Server Profiler I can see the OnNeedDataSouce query works and returns data. If I change the grid to populate with the column being set to upper case it works. If I Remove the CaseSensitive it works. Why is it having an issue with the filter with a radcombo box?
<GroupingSettings CaseSensitive="false" /> <ExportSettings> <Excel Format="Html" /> </ExportSettings> <AlternatingItemStyle BackColor="#EEEEEE"></AlternatingItemStyle> <MasterTableView DataKeyNames="AdvisorBlotterID" PagerStyle-Mode="NextPrevNumericAndAdvanced"> <Columns> <telerik:GridBoundColumn SortExpression="ClientName" DataField="ClientName" HeaderText="Client Name" > <FilterTemplate> <telerik:RadComboBox ID="RadComboBoxClientName" DataTextField="ClientName" DataValueField="ClientName" AppendDataBoundItems="true" Width="150px" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ClientName").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="ClientNameIndexChanged" Skin="Office2007"> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server"> <script type="text/javascript"> function ClientNameIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); if (args.get_item().get_value() == "0") { tableView.filter("ClientName", args.get_item().get_value(), "NoFilter"); } else { tableView.filter("ClientName", args.get_item().get_value(), "EqualTo"); } } </script> </telerik:RadScriptBlock> </FilterTemplate> <ItemStyle VerticalAlign="Top" /> </telerik:GridBoundColumn>