title: How to query datetime based on date in c#
body: <p>I have an MS-Access database with a DateTime column.<br>
  ex: <code>03/08/2009 12:00:00 AM</code>.</p>
  
  <p>I want query based on date like:</p>
  
  <pre><code>select * from tablename where date='03/08/2009'
  </code></pre>
  
  <p>I want display data as <code>03/08/2009 12:00:00 AM</code>.</p>
  
  <p>How would I write this query in C#?
  Please help me.</p>