Disable Automatic Filtering

[Raimund]

Hello,

someone knows how to only disable the automatic filtering operation
when performing a filter on a row?

I need to filter a DropDown Column - so i just want to modify the gridview datasource selectcommand

It works - but just the first time and then i get this error
No property or field 'filterExpression' exists in type 'DataRowView' - its because my row is a DropDown

At the gridviews ItemCommand Event im using this code

if (e.CommandName == RadGrid.FilterCommandName)
{
    gvUser.MasterTableView.FilterExpression = ""; //tried with this ... but does not work
    Pair filterPair = (Pair)e.CommandArgument;
    //string s = filterPair.First + ", " + filterPair.Second;

    TextBox txtFilterTextBox = (e.Item as GridFilteringItem)[filterPair.Second.ToString()].Controls[0] as TextBox;
    string filterValue = txtFilterTextBox.Text;

    srcGv.SelectCommand = "SELECT * FROM [Table1] WHERE [ID] IN (SELECT [ID] FROM [Table2] WHERE [someRow] LIKE '%" + txtFilterTextBox.Text + "%')  ORDER BY [someRow]";
    gvUser.Rebind();
}

i think i just have to disable the automatic filter operation but i cant find where i can disable it ...

Greetings - Raimund

[Tsvetina]

Hi Raimund,

Have you tried by cancelling the filter command? This prevents the grid from performing its default filtering:

if (e.CommandName == RadGrid.FilterCommandName)
{
     e.Canceled=true;
     //the rest of your code logic
}

Regards,
Tsvetina
the Telerik team

[Raimund]

Yay,

it works.

Thank you very much