narasiman rao

narasiman rao

  • NA
  • 519
  • 771.6k

what date i insert in the run mode that date is not saved DB

Dec 24 2012 3:36 AM


i have to fields as follows

fromdate  calendarimage


Todate   calendarimage

which date i choose that date displayed both in the fromdate and todate.but in the database date stored in the format as 1/1/1900 12:00:00 AM.

why?

fromdate and todate datatype is datetime in the database.

when i insert the date for this query as follows 

SqlCommand cmd = new SqlCommand("insert into BirthDayWish values('" + txt_name.Text + "','" + FromDate.SelectedDateValue.ToString() + "','" + txt_mobile.Text + "','" + Todate.SelectedDateValue.ToString() + "','a','" + txt_Email.Text + "')", con);

please help me.

Answers (2)