title: Filter datatable between two dates
body: <p>I have a column within my database called "Month". What i want to do is filter the table between two months. Example of this is March - June. I have code which works BUT only works alphabetically</p>
  
  <pre><code>string strquery = "select * from tbl_DR_data ";
  string strq2 = "where";
  
  if (DropDownList6.SelectedItem.Text != "All" &amp;&amp; DropDownList8.SelectedItem.Text != "All") {
      string month1 = DropDownList6.SelectedItem.Text.ToString();
      string month2 = DropDownList8.SelectedItem.Text.ToString();
      strq2 = strq2 + "[Month] BETWEEN'" + month1 + "'AND'" + month2 + "'";
  }
  </code></pre>
  
  <p>When <code>DropDownList6 = March</code> and <code>DropDownList8 = June</code>. Nothing appears in the gridview which im binding BUT if the swap them around so DDL6= June and DDL8 = March it works :S</p>
  
  <p>Is there a work around so that i can have the months ordered in how the months are meant to be instead of being alphabetical </p>