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
>