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

Programmatic filtering problems

6 Answers 200 Views

GridView

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

Jon asked on 11 Jun 2009, 11:10 AM

Hi,

I have an application in which I will need to scan a barcode and then the matching record is displayed in a gridview. Then the next bacode will be scanned and added etc.

To that end I have got the scanning bit working and as each new barcode is scanned it gets added to an array. I need to be able to get those array entries setup as the filter of the gridview.

I would like to do this by setting up an initial filter that will search for record -1 which doesn't exist and as such the grid will be empty. Then I can add the items in one at a time. It would be nice and easy if I could do some form of an COLUMNNAME IN (1,2,3) operation on the grid like in SQL.

I have the following code present to add the column IDs to the filter. It doesn't work. I've tried a gridview refresh afterwards and no luck.

    
            Dim filter As Telerik.WinControls.Data.FilterExpression = New Telerik.WinControls.Data.FilterExpression()  
        
            For Each columnID As String In columnIDs  
        
            filter.Predicates.Add(Telerik.WinControls.Data.FilterExpression.BinaryOperation.OR, Telerik.WinControls.UI.GridKnownFunction.EqualTo, columnID)  
        
            Next 
        
            uxRadGridView.Columns("ColumnID").Filter = filter

Any ideas?

best Regards,

Jon

6 Answers, 1 is accepted

answered on 12 Jun 2009, 06:29 PM

Hi Martin,

Thanks for that - it works just fine now. The odd thing was that when I was setting the filter to not be visible via the designer it then didn't work but there could have been some other issue there I suppose.

I am still getting one problem with my code that you may have an idea on. A lot of the time when I rebuild the filter after having taken out a value from it the grid doesn't seem to refresh although a click on the grid seems to kick it in. The odd thing is that if I step through the code it all works and always refreshes the grid properly, the problem ONLY appears when I let the code run straight through with no pauses. Any thoughts?

Regards,

Jon