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

Filter on "Contains" problem

9 Answers 178 Views

GridView

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

9 Answers, 1 is accepted

answered on 16 Sep 2008, 03:44 PM

Hi Lamees Afify,

Thank you for your question.

There is a work-around for this issue. You have to create a hidden string column:

    
            GridViewTextBoxColumn c = new GridViewTextBoxColumn();  
        
            c.DataType = typeof(string);  
        
            c.IsVisible = false;  
        
            this.radGridView1.MasterGridViewTemplate.Columns.Add(c);  
        
            c.Expression = "databasefieldhere";

Please take care of adding this column just once, because the grid will consume too much memory.

Then you have to create a custom filter:

    
            FilterExpression filter = new FilterExpression(FilterExpression.BinaryOperation.AND, GridKnownFunction.Contains, GridFilterCellElement.ParameterName);  
        
                        ParameterValuePair p = new ParameterValuePair(GridFilterCellElement.ParameterName, "99");  
        
                        filter.Parameters.Add(p);  

                        c.Filter=Filter;

Then you can modify the filter using this code:

    
            p.Value="filtervalue"

Feel free to contact me if you have any further questions.

Best wishes,
Nick
the Telerik team

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

answered on 21 Feb 2014, 03:27 PM

FilterValue.png

Hello Samira,

Thank you for contacting us.

The provided information is not enough for me to reproduce the problem on my end. The value in the filter cell is stored after filtering. Please refer to the attached screen shot. Could you please specify the exact steps how to reproduce the problem or get back to me with a sample code snippet so I can investigate the precise case? Information about the installed Telerik UI for WinForms version will be useful. Thank you in advance.

I am looking forward to your reply.

Regards,
Desislava
Telerik

answered on 22 Feb 2014, 12:04 PM

untitled.png

Hello Desislava,
I wanted to filter a numeric column so I added a hidden column to the grid . When user entered the filter value in main column, the grid filtered but filter value at main column disappeared.

answered on 27 Feb 2014, 07:10 AM

FilterValue.png

Hello Samira,

Thank you for writing back.

I am still unable to reproduce the problem on my end with the latest version. I would kindly ask you to provide same code snippet, which successfully reproduces the issue. Thus, we would be able to investigate the specific case and assist you further. Thank you in advance for the co-operation.

I am looking forward to your reply.

Regards,
Desislava
Telerik