how to set calendar selected date in mm/dd/yyyy and insert into sql server 2005

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!
:)