Alex Rivera | Logout

DataGridView Filter a BindingSource with a List of object as DataSource

Asked 2012-04-09T13:35:45.997
18

I'm trying to filter a BindingSource with a BindingList as Datasource. I tried BindingSource.Filter = 'Text Condition' But it didn't work, nothing happens, the data on screen remains the same. But if i use a DataSet as the datasource it works. Is It possible to filter a list of objects with the BindingSource.Filter property?

I have the following class:

class Person
        {
            public String Nombre { get; set; }
            public String Apellido { get; set; }
            public int DNI { get; set; }
            public int Edad { get; set; }
            public Decimal Tamano { get; set; }
        }

This is how i use it:

BindingList<Person> personas = new BindingList<Person> { 
                new Person{ Apellido = "App1", DNI = 3011, Edad = 20, Nombre ="Name1", Tamano = new decimal(1.7)}
                ,new Person{ Apellido = "App2", DNI = 1520, Edad = 30, Nombre ="Name2", Tamano = new decimal(1.5)}
                ,new Person{ Apellido = "App3", DNI = 5654, Edad = 21, Nombre ="Name3", Tamano = new decimal(1.6)}
                ,new Person{ Apellido = "App4", DNI = 778, Edad = 40, Nombre ="Name4", Tamano = new decimal(1.68)}
            };

            BindingSource bs = new BindingSource();
            bs.DataSource = personas;
            grid.DataSource = bs;

            bs.Filter = "Apellido like 'App1'";

This is just an example the idea is to test if a can filter a data source like that. I will use the knowledge inside a new project.

pd: The idea is to be able to use BindingSource.Filter if it is possible.

Edit
Report

1 Answer

1

I think it is because the BindingSource doesn't know what type of data it is filtering. Once a data is converted to dataset into columns and rows, filter can run. Because your datasource is a class, it can't do the automatic filtering.

answered 2012-04-09T13:40:50.293

Your Answer