title: How to filter month and year from datatable "Date" column and get matching filter rows in ASP.Net
body: <p>In my application I need to filter all matching records from date column in datatable</p>
  
  <pre><code>DataRow[] dr= dt.Select(
                  "date where date='" + 
                  Convert.ToString(txtmonth.Text) + "' and '" +
                  Convert.ToString(txtyear.Text) + "'");
  </code></pre>
  
  <p>Here I'm getting error how can I filter based on month and year from datatable date column</p>