title: Showing date in MM/DD/YY format in a gridview column from .cs page/rowdatabound?
body: <p>I am getting a date time field from database with timestamp.</p>
  
  <p>My grid has an auto-generated column.</p>
  
  <p>I am formatting it in my <code>.cs</code> page </p>
  
  <pre><code>dsWorkItems.Tables[0].Rows[count]["Date"] =
                      !string.IsNullOrEmpty(dsWorkItems.Tables[0].Rows[count]["Date"].ToString()) ?
                      ((DateTime)(dsWorkItems.Tables[0].Rows[count]["Date"])).ToShortDateString(): "";
  </code></pre>
  
  <p>In quick watch I am getting </p>
  
  <pre><code>((DateTime)(dsWorkItems.Tables[0].Rows[count]["Date"])).ToShortDateString() as 9/26/2013  
  </code></pre>
  
  <p>but in grid I am getting <code>9/26/2013 12:00:00 AM</code> but I want to show in grid <code>9/26/13</code></p>
  
  <p>And one more thing is it possible to show the full datetimestamp value from database in cell tooltip..</p>
  
  <p>I have tried </p>
  
  <pre><code> dsWorkItems.Tables[0].Columns["Date"].DefaultCellStyle.Format = "MM/dd/yy";
  </code></pre>
  
  <p>but DefaultCellStyle assembly missing i added System.Windows.Form but still not worked</p>