This is a migrated thread and some comments may be shown as answers.

template filtering

9 Answers 143 Views

Grid

This is a migrated thread and some comments may be shown as answers.

9 Answers, 1 is accepted

answered on 22 Mar 2009, 08:58 AM

i tried the cliend side filtring and it still not working

it produced a expression expected error....here is my vbcode

Protected Sub FilterCombo_SelectedIndexChanged_support(ByVal o As Object, ByVal e As RadComboBoxSelectedIndexChangedEventArgs)

Dim filterExpression As String

filterExpression = "([support_zone] = '" + e.Value + "')"

RadGrid2.MasterTableView.FilterExpression = filterExpression

RadGrid2.MasterTableView.Rebind()

zone_source.SelectCommand = "SELECT [Zone] FROM [Support_Zone_Zone] WHERE Support_zone=Support"

zone_source.SelectParameters.Clear()

zone_source.SelectParameters.Add("@support", TypeCode.String, e.Value.ToString)

zone_source.DataBind()

End Sub

i am working on this issue for 2 days :S please help ASAP

answered on 25 Mar 2009, 08:15 AM

Hello Ibrahim,

From the server side perspective, once an item in the combo is selected, and the SelectedIndexChanged event is raised, you can get the new value, and set the filter expression of the control accordingly. This will look like this:

ASPX:

    
            <telerik:GridBoundColumn DataField="CategoryName" HeaderText="CategoryName" SortExpression="CategoryName" 
        
            UniqueName="CategoryName">  
        
            <FilterTemplate> 
        
            <telerik:RadComboBox runat="server" ID="FilterCombo" DataSourceID="AccessDataSource1" 
        
            DataValueField="CategoryName" DataTextField="CategoryName" AutoPostBack="true" 
        
            OnSelectedIndexChanged="FilterCombo_SelectedIndexChanged">  
        
            </telerik:RadComboBox> 
        
            </FilterTemplate> 
        
            </telerik:GridBoundColumn>

VB:

    
            Protected Sub FilterCombo_SelectedIndexChanged(o As Object, e As RadComboBoxSelectedIndexChangedEventArgs)  
        
             Dim filterExpression As String 
        
             filterExpression = "([CategoryName] = '" + e.Value + "')" 
        
             RadGrid1.MasterTableView.FilterExpression = filterExpression  
        
             RadGrid1.MasterTableView.Rebind()  
        
            End Sub

Additionally if this not helps, please open a formal support ticket and send us a small sample application that isolates the problem, so we can check it.

I hope this helps.

Sincerely yours,
Pavlina
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

answered on 26 Mar 2009, 04:15 PM

Hi ibrahim,

Try to examine the code from the following live demo (the first RadGrid) and see if the approach there would work for you:
Filter Template

Note that the important properties that has to be synchronized are DataField/binding expression for the column and the SelectedValue for the combobox filter (which has to match the CurrentFilterValue of the column). The filtering is triggered intercepting the OnClientSelectedIndexChanged event of RadComboBox and calling the filter(colUniqueName, valueToCompare, filterFunction) client method of the grid.

I hope this helps.

Kind regards,
Pavlina
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.