title: BindingSource Cannot perform 'Like' operation on System.DateTime and System.String
body: <p>I want to filtre a datagridview using a searchbox , I have a function that works great with strings but I don't know why I get an exception when I use this function with a column that contains int/date values : </p>
  
  <pre><code> public void SearchTable(TextBox searchBox, String columnNameToSearch, int Type)
      {
          BindingSource bs;
          switch (Type)
          {
              case NUMERIC_COLUMN:
                  bs = new BindingSource
                  {
                      DataSource = _dgv.DataSource,
                      Filter = columnNameToSearch + " = " + searchBox.Text.Trim()
                  };
                  _dgv.DataSource = bs;
                  break;
              case TEXT_COLUMN:
                  bs = new BindingSource
                  {
                      DataSource = _dgv.DataSource,
                      Filter = columnNameToSearch + " LIKE '" + searchBox.Text.Trim() + "%'"
                  };
                  _dgv.DataSource = bs;
                  break;
          }
      }
  </code></pre>
  
  <p>this is the exception :
  <a href="http://i.stack.imgur.com/IU1Xr.png" rel="nofollow">http://i.stack.imgur.com/IU1Xr.png</a></p>
  
  <p>When I try the query in SQL server the query works</p>