in c#.net we are taking datetime from datetimepicker we are storing datetime into sqlserverdatabase.
in sqlserver we are taking datetime datatype.

we write code like this:
Datetime dt=DateTimePicker1.value;
cmd=new sqlcommand("insert into values(date) tablename('"+dt+"')",con);
cmd.excutenonqury();

we are seleted date datetimepicker as 19/12/2006
after excuting this one we are getting error like this:
conversion of char data type to datetime data type resulted in an out of range datetime value