BindingList Filter on Linq to SQL bindingsource

Question

Is it possible to Filter a BindingList passed to a bindingsource control:

private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Length == 0)
{
     productBindingSource.Filter = null;
}
else
{
     productBindingSource.Filter = "ProductName = '" + textBox1.Text + "'";
     //productBindingSource.RemoveFilter();
}
}

Thanks in advance.

Samio · Answer

After searching I found that it is not possible to filter on a basic BindingList for doing so some alternative exists like implementing an IEnumerable or using BindingListView or similar... After implementing the BindingList in the project the next code can be used inside Button click event: var qry = (from p in dc.Products select p).ToList(); BindingList list = new BindingList (qry); IEnumerable sel = list.Where(m => m.ProductName. Contains (Ch) == true); BindingSource1.DataSource = sel;