c# - Error conversion of a varchar data type to a datetime data type resulted in an out-of-range value -

i inserting date database, , error

the conversion of varchar data type datetime data type resulted in out-of-range value.

my database like

column   datatype ----------------- id       int date     datetime 

my current date format dd/mm/yyyy. didn't accept. when changed format (made changes in system calender not in programming) yyyy/dd/mm, works.

why above format not work?

my query is

cmd = new sqlcommand("insert tblnewaccount values ('" + id + "','" + datetimepicker1.text + "')", con);  cmd.executenonquery(); 

why above format not work?

i don't care , neither should. because doing terribly wrong here using right format.

you try save datetime values string representation in datetime typed column. should choose right data type values.

• bad habits kick : choosing wrong data type

first, don't use text property of datetimepicker, use value property value datetime. , should use parameterized queries. kind of string concatenations open sql injection attacks.

using(var con = new sqlconnection(constring)) using(var cmd = con.createcommand()) {     cmd.commandtext = @"insert tblnewaccount                         values (@id, @date)";     cmd.parameters.add("@id", sqldbtype.int).value = id;     cmd.parameters.add("@date", sqldbtype.datetime).value = datetimepicker1.value;     con.open();     cmd.executenonquery(); }