check your system time format
for example :
my system time format is 20/Dec/2013 that means dd/MMM/yyyy
DateTime dtime = DateTime.Parse(DateTime.Now.ToShortDateString());
string Sdtime = dtime.ToString("dd/MMM/yyyy");
and when insert date into table you convert the string to datetime format
Note
table column field must have "date" datatype