title: How to select data between two dates in C# using ms access
body: <p>i want to know how to select data between two dates i am using query but i get null data please help me
  What I have tried:</p>
  
  <pre><code>DataSet dsa = new DataSet();
  DataTable dt1 = new DataTable();
  dsa.Tables.Add(dt1);
  OleDbDataAdapter da = new OleDbDataAdapter();
  da = new OleDbDataAdapter("SELECT [Column1],[Column2],[Column3],[Date],[Receipt No],[Delivery Person] from [Total] Where [Date] between " + dateTimePicker2.Value.ToShortDateString() + " AND #" + dateTimePicker3.Value.ToShortDateString() + "#", VCON);
  da.Fill(dt1);
  </code></pre>