title: vb.net get database data between two date
body: <p>I have two datetimepicker, startDate is stored datetimepicker1 value and endDate is stored datetimepicker2 value.</p>
  
  <p>I want to to get the data between startDate and endDate from database.</p>
  
  <pre><code>Dim bSql As String = "select date, sum(total_price)  from bill  where Date = '" &amp; Format(startDate, "yyyy/MM/dd") &amp; " and Date='" &amp; Format(endDate, "yyyy/MM/dd") &amp; "'"
  </code></pre>
  
  <p>i tried the code above but it can't work. Anyone can help me?</p>