title: DATE BIND IN DROP DOWN LIST
body: <p>This is Query which i can get all record which is fall between in both dates.</p>
  
  <pre><code>SELECT * FROM tblBooking WHERE  
   Convert(datetime,'2013-08-20 04:00:00.000')  --start date  
      BETWEEN FromDateWithStartTime AND ToDateWithEndTime  
      OR Convert(datetime,'2013-08-30 04:00:00.000') --endDate  
      BETWEEN FromDateWithStartTime AND ToDateWithEndTime  
      or FromDateWithStartTime BETWEEN Convert(datetime,'2013-08-20 04:00:00.000') --startdate  
       AND Convert(datetime,'2013-08-30 04:00:00.000')  --enddate  
      or ToDateWithEndTime BETWEEN Convert(datetime,'2013-08-20 04:00:00.000')--start date  
      AND Convert(datetime,'2013-08-30 04:00:00.000')
  </code></pre>
  
  <p>and in C# i an fetching start Date and End Date.</p>
  
  <blockquote>
    <p>FromDateWithStartTime =
    Convert.ToDateTime(dt.Rows[0]["Fdate"]).ToString("yyyy/MM/dd
    HH:mm:ss");</p>
    
    <p>ToDateWithEndTime = Convert.ToDateTime(dt.Rows[0]["Edate"]).ToString("yyyy/MM/dd
    HH:mm:ss");</p>
  </blockquote>
  
  <p>I want those date which is fall between START DATE AND END DATE.
  AND BIND ALL DATES IN THE DRP DOWN LIST.
  HOW I CAN DO IT.</p>