title: Date data type coming up as 12:00 am
body: <p>Ok.  In visual studio I have a table to display a summery of data.  All of my data with the "date" datatype comes up with the with the date that we entered.  However they all show 12:00 AM after the date.  The following is some sample output when I tie this table to a webform.</p>
  
  <p>Edit Delete Details  6/20/2012 12:00:00 AM  28<br>
  Edit Delete Details  6/21/2012 12:00:00 AM  11<br>
  Edit Delete Details  6/25/2012 12:00:00 AM  34<br>
  Edit Delete Details  6/26/2012 12:00:00 AM  14<br>
  Edit Delete Details  6/27/2012 12:00:00 AM  45<br>
  Edit Delete Details  6/29/2012 12:00:00 AM </p>
  
  <p>Can I fix the 12:00AM to time entered or the current time?</p>
  
  <p>I do not want to use varchar or int or any other data type becasue when our employees look at our data summary it sorts it by the primary key.  With the other data types it sorts it wrong.</p>
  
  <p>Thanks again.</p>
  
  <p>I am working with Visual studio 2010 its a C# web app and SLQ Server 2012 Enterprise.</p>