Applying a filter to a BindingSource, but it doesn't work

Question

I have a TextBox, in which I put a phrase, which is either the description of a task or the id of a task. I want to filter a list using the text from this TextBox. But when I put text into this TextBox, filtering doesn't work, and the collection in the DataGridView doesn't change.

What can be wrong?

public void BindData()
{
    var emptyBindingSource = new BindingSource();
    dataGridViewTaskList.AutoGenerateColumns = false;
    dataGridViewTaskList.DataSource = emptyBindingSource;

    var taskList = GetTasks();

    _bindingSource = new BindingSource();
    _bindingSource.DataSource=taskList.Response;

    dataGridViewTaskList.AutoGenerateColumns = false;

    dataGridViewTaskList.DataSource = _bindingSource.DataSource;

    if (dataGridViewTaskList.Columns["gridViewColumnId"] == null)
        dataGridViewTaskList.Columns.Add(new DataGridViewColumn() {Name = "gridViewColumnId"});
    else
        dataGridViewTaskList.Columns["gridViewColumnId"].DataPropertyName = "Id";

    if (dataGridViewTaskList.Columns["gridViewColumnDescription"] == null)
        dataGridViewTaskList.Columns.Add(new DataGridViewColumn() {Name = "gridViewColumnDescription"});
    else
        dataGridViewTaskList.Columns["gridViewColumnDescription"].DataPropertyName = "Description";
}

private void tbSearchedPhraseOrId_TextChanged(object sender, EventArgs e)
{
    _bindingSource.Filter = string.Format("Id = '{0}'", tbSearchedPhraseOrId.Text);
}

I added the following in BindData method and it doesn't work either:

_bindingSource.Filter = string.Format("Id LIKE '%{0}%'", "23");

Designer:

this.dataGridViewTaskList.AllowUserToAddRows = false;
this.dataGridViewTaskList.AllowUserToDeleteRows = false;
this.dataGridViewTaskList.AllowUserToOrderColumns = true;
this.dataGridViewTaskList.AllowUserToResizeRows = false;
this.dataGridViewTaskList.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                        | System.Windows.Forms.AnchorStyles.Left)
                        | System.Windows.Forms.AnchorStyles.Right)));
this.dataGridViewTaskList.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
this.dataGridViewTaskList.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.dataGridViewTaskList.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridViewTaskList.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.gridViewColumnId,
this.gridViewColumnDescription});
this.dataGridViewTaskList.Location = new System.Drawing.Point(6, 62);
this.dataGridViewTaskList.MultiSelect = false;
this.dataGridViewTaskList.Name = "dataGridViewTaskList";
this.dataGridViewTaskList.ReadOnly = true;
this.dataGridViewTaskList.RowHeadersVisible = false;
this.dataGridViewTaskList.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this.dataGridViewTaskList.Size = new System.Drawing.Size(414, 488);
this.dataGridViewTaskList.TabIndex = 0;

score 8 · Accepted Answer · answered Sep 19 '10 at 20:06

8

According to the documentation, your underlying data source (i.e. your task list) must implement the IBindingListView interface to have a working Filter property. Are you sure this is the case right now?

(As an aside, you should set the DataSource property of your DataGridView to the BindingSource object itself rather than the BindingSource.DataSource property.)

answered Sep 19 '10 at 20:06

Alan

6,501
1
28
24

You have right. as DataSource of BindingSource is set array :/ – user278618 Sep 24 '10 at 07:01
@user278618 can you please how did you do it? – Volatil3 May 05 '13 at 20:48

score 4 · Answer 2 · edited Aug 20 '17 at 18:05

4

You can always check _bindingSource.SupportsFiltering to see if the BindingSource type supports filtering

edited Aug 20 '17 at 18:05

Jason Roman

8,146
10
35
40

answered Aug 20 '17 at 17:41

s klein

41
2

score 1 · Answer 3 · answered Sep 24 '10 at 09:35

You should change:

dataGridViewTaskList.DataSource = _bindingSource.DataSource;

to

dataGridViewTaskList.DataSource = _bindingSource;

By changing _bindingSource.Filter you're not actualy changing _bindingSource.DataSource - it stays the same and because of that dataGridViewTaskList.DataSource doesn't change either. In the other hand, _bindingSource is changed, and you can bind directly to it to get that change.

score 0 · Answer 4 · answered Sep 16 '10 at 13:50

0

Did you try with:

_bindingSource.Filter = string.Format("gridViewColumnId = '{0}'", tbSearchedPhraseOrId.Text);

Can you define taskList structure?

answered Sep 16 '10 at 13:50

watbywbarif

6,487
8
50
64

score 0 · Answer 5 · edited Dec 10 '13 at 17:17

0

Try to call : _bindingSource.ResetBindings(false); after setting filter.

Also you can try to call:

dataGridViewTaskList.ResetBindings();
dataGridViewTaskList.Refresh();
dataGridViewTaskList.Update();

edited Dec 10 '13 at 17:17

gunr2171

16,104
25
61
88

answered Sep 17 '10 at 13:23

Serhiy Prysyazhnyy

99
10

score 0 · Answer 6 · answered Jul 09 '18 at 06:19

0

Alternative IEnumerable, List.....etc Global Variable

listBindingSource.DataSource = List();

Then simple filter the list and Re-assign it listBindingSource.DataSource = List.FindAll(t => t.x == yourValue);

answered Jul 09 '18 at 06:19

zaffar ullah

1

You need to sort out the format of your answer. You can see a preview below the editing window. It is also advisable to write a better explanation. And lastly, even though your suggestion will work in practice, it's not good programming. – Shai Jul 09 '18 at 06:48

Applying a filter to a BindingSource, but it doesn't work

6 Answers6

Linked