title: Filtering datagridview by textbox change
body: <p>Using Linq to sql through bindingsource control in WinForms, I could not get this to work:</p>
  
  <pre><code>private void textBox1_TextChanged(object sender, EventArgs e)
  {
              productBindingSource.Filter = string.Format("ProductName LIKE '*{0}*'", textBox1.Text);
              MessageBox.Show("Changed");
  }
          NorthwindDataContext dc;
          private void FrmFilter_Load(object sender, EventArgs e)
      {
          // create new data context
          dc = new NorthwindDataContext();
  
          // set the binding source data source to the full order table
          var qry = (from p in dc.Products select p).ToList();
          this.productBindingSource.DataSource = dc.GetTable&lt;Product&gt;();
      }
  </code></pre>
  
  <p>When I type some letter in the textbox nothing happens in the datagridview.
  Thanks for advices ...</p>