I tried this code to filter radgrid from the external radcombox located outside the Grid. And i have a problem with it. Visual Studio debugger and SQL Profiler show that this code works and send to radgrid correct filter expression with the correct filter value. But radgrid doesn't filtrate data with this expression while rebinding. It shows all data without any filtering after rebinding. How can I solve it?
This is my code C#:
protected void RadComboBox1_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e){ radgrid.MasterTableView.FilterExpression = "[service_id] LIKE '%" + ddlService.SelectedValue + "%' "; GridColumn column = radgrid.MasterTableView.GetColumnSafe("serv_id"); column.CurrentFilterFunction = GridKnownFunction.EqualTo; column.CurrentFilterValue = ddlService.SelectedValue; column.AndCurrentFilterFunction = GridKnownFunction.EqualTo; radgrid.MasterTableView.Rebind();}This is my code ASPX:
<telerik:RadComboBox ID="ddlService" runat="server" Height="200" Width="240" DropDownWidth="310" DataSourceID="dsServices" EmptyMessage="- Select Product -"HighlightTemplatedItems="true" CausesValidation="false"Filter="Contains" AppendDataBoundItems="true"onselectedindexchanged="RadComboBox1_SelectedIndexChanged"SelectedValue='<%# radgrid.MasterTableView.GetColumn("serv_id").CurrentFilterValue %>'AllowCustomText="true" AutoPostBack="true" DataTextField="service_name" DataValueField="id">