filter property of grid view

[salini]

can i have a list of values on a filter property like equals
actually i want to have a drop down on a filter which will be having some list of values from that column from which the client can select and get the results on the grid.
thanks in advance

[Svett]

Hi salini,

Thank you for writing to us.

If I understand you properly, you want to replace the default editor with a drop down list containing the filtering values. You can achieve that by using the EditorRequired event:

private void radGridView1_EditorRequired(object sender, EditorRequiredEventArgs e)
{
    if (this.radGridView1.CurrentRow is GridViewFilteringRowInfo)
    {
        RadDropDownListEditor dropDownEditor = new RadDropDownListEditor();
        RadDropDownListEditorElement editorElement = dropDownEditor.EditorElement as RadDropDownListEditorElement;
        editorElement.ValueMember = "ID";
        editorElement.DisplayMember = "Name";
        editorElement.DataSource = Data.GetDummyEmployees();
        e.Editor = dropDownEditor;
    }
}

If you need further assistance, do not hesitate to write us back.

Greetings,
Svett
the Telerik team

[salini]

hi
i am using q3 version of telerik
i want to know that can i set custom values( like result from a stored procedure) to the showcolumnheaderproperty of a grid view.
i dont want the filter column header property to have distinct values from the grid view column rather i want it  to bind to a stored procedure
please help!

[Svett]

Hi salini,

As I mentioned, you can replace the default editor by handling the EditorRequired event. You can refer to my previous post for additional information. If you want to change the data source of GridViewComboBoxColumn cells, you should use the CellEditorInitialized event: 

private void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)
{
    if ((this.radGridView1.CurrentCell is GridFilterCellElement))
    {
        if (this.radGridView1.CurrentCell.ColumnInfo.Name == "ColumnName")
        {
            RadDropDownListEditor editor = this.radGridView1.ActiveEditor as RadDropDownListEditor;
            RadDropDownListEditorElement element = editor.EditorElement as RadDropDownListEditorElement;

            element.DataSource = GetEditorFilterDataSource();
            element.DisplayMember = "Display";
            element.ValueMember = "Value";
        }
    }
}

Kind regards,
Svett
the Telerik team