Insert Datetimepicker text in SQL Database

Question

how to Insert Datetimepicker text in SQL Database as datetime datatype

Answer 1

Parse the text in C#, and insert the parsed DateTime. Example:

var date = new DateTime(dateTimePickerText);
InsertIntoSqlDatabase(date); // Code for inserting here.

Answer 2

In order to parse the datetime from datetime picker you can do the following:

string dt = dateTimePicker.Value.ToString("yyyy-mm-dd hh:MM:ss");

And then in order to insert it in your database you can do:

Insert into table (id, mytime) 
values("5",  CONVERT(datetime, CONVERT( varchar(11), dt, 101))

If you need information on how to access your database you can read the following article in CodeProject