Insert date written to the textbox in a certain format for the database

Question

Code:

private void button1_Click(object sender, EventArgs e)
{
  conn.Open();
  using (SqlCommand cmd = new SqlCommand("INSERT INTO (StartDate) 
  VALUES(@StartDate)", conn))
  {                                  
    cmd.Parameters.AddWithValue("@StartDate", txtStartDate.Text);
    cmd.ExecuteNonQuery();
  }
}

Wanted the format that the user write in Textbox were this:

2017-09-26 11:24:39.693

When I write this value on textbox and clicking on the button generates this error: Converting a data type nvarchar in a data type datetime resulted in a value outside the range.

How do I fix it?

Another question, how can I make one Datetimepicker in this format:

2017-09-26 11:24:39.693

And send it to the database when you click the button, same as the code above?

Answer 1

Convert your text to a format datetime in this way

cmd.Parameters.AddWithValue("@StartDate", DateTime.ParseExact(txtStartDate.Text, "yyyy-MM-dd HH:mm:ss", null););

To set a Datetimepicker for a format specific, just use the following code:

seuDateTimePicker.CustomFormat = "yyyy-MM-dd HH:mm:ss"

where the format you want would be "yyyy-MM-dd HH:mm:ss"

or the format can be changed directly in the Customformat property of Datetimepicker