title: How to find the rows containing the match string in datatable in my case?
body: <p>I have a combo box which contains the years, Exampple: 2016,2017,2018  etc.</p>
  
  <p>I have dt which has 5 columnc which contains date in 3 columns which are by name paydate,begindate, enddate. But the format of each date is dd/mm/yyyy .</p>
  
  <p>What i have to do ?</p>
  
  <p>I have to find all the rows which contains the selected year in combobox (cboYear). It could have been much simpler if there was just years in the rows of datatable but it has day and month with "/"
      so it is not able to match the string "2016" with "01-12-2016" and returns no rows by the folowing query :</p>
  
  <pre><code>//this cboYear.Text has lets say "2016 and paydate and other two column has date in format "dd/mm/yyyy""
   DataRow[] foundAuthors = dt2.Select("paydate= '" + cboYear.Text + "'" + " and " + "begindate= '" + cboYear.Text + "'" + " and " + "enddate= '" + cboYear.Text + "'");
   if (foundAuthors.Length != sdgvPayDates.Rows.Count-1)
   {
         MessageBox.Show("All rows must have same year as the selected year in combobox");
         return false;
   }
  </code></pre>
  
  <p><strong>How to get the rows which contains the selcted year by finding effective matching?</strong></p>
  
  <p>If soemthing like  "like" operator in LINQ also exist ? so that it just find all the matching rows so that it could find the row even when "2016" the datatable contains 01/02/2016 format . Datatable contains this <a href="http://prntscr.com/ccx3zn" rel="nofollow">http://prntscr.com/ccx3zn</a></p>