select query BETWEEN two dates in WindowsForms Application c#
<p>I have a problem with the query BETWEEN .I'm trying to select records from a table between two dates, SO, I used the following query :</p>

<pre><code>SqlDataAdapter sda1 = new SqlDataAdapter(
  "select distinct * from BLC where DATE_BLC between '" + 
   dateTimePicker1.Value.ToString() + "' and'" + 
   dateTimePicker2.Value.ToString() + "'", conx);
</code></pre>

<p>When I enter the following dates :</p>

<p>From  date 05/02/2016  To date 15/03/2016</p>

<p>It returns the records between (06/02/2016 to 15/03/2016) date but the records that begin with date 05/02/2016 , they are not returned.
and when I choose the date (From 05/02/2016 to 05/02/2016 ) there is no records here.
Can someone tell me what I'm doing wrong here?</p>