title: Date and Time in datagridview
body: <p>somebody help me with the problem that every time i save or update a data the date is working fine but the time is always 12:00AM. the time should be the time when I input the data and be saved into the database.</p>
  
  <p>this is my code for the update</p>
  
  <pre><code>        Dim i As Short
      con.Open()
      Using com As New SqlClient.SqlCommand("UPDATE Information set FiveS_Date = '" &amp; DateTimePicker1.Text &amp; "',FiveS_Score = '" &amp; TextBox2.Text &amp; "',FiveS_Total = '" &amp; TextBox3.Text &amp; "' ,FiveS_Percentage = '" &amp; TextBox4.Text &amp; "' WHERE Id='" &amp; id &amp; "'", con)
          i = com.ExecuteNonQuery()
      End Using
      con.Close()
      If (i &gt; 0) Then
  
  
          MsgBox("Training updated successfully", MsgBoxStyle.Information)
      End If
  </code></pre>
  
  <p>please help.</p>