StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODataGridView Filter a BindingSource with a List of object as DataSource
text
Body
copied!<p>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?</p> <p>I have the following class:</p> <pre><code>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; } } </code></pre> <p>This is how i use it:</p> <pre><code>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'"; </code></pre> <p>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.</p> <p>pd: The idea is to be able to use BindingSource.Filter if it is possible.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload