i have to fields as follows
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.
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.