display date in textbox in dd-mm-yyyy format
Textbox1.Text = CalendarControl1.Value.ToString("dd/MM/yyyy");
when inserting in database format should be yyyy/MM/dd
so, if not using storeprocedure then
"Insert into .... values(...,'" + CalendarControl1.Value.ToString("yyyy/MM/dd") + "',...)"
if inserting using sp then
Parameters.AddWithValue("@date1", CalendarControl1.Value, SqlType.DateTime)
Happy Coding!
:)