how to convert datetime in string

example :

string sDate = DateTime.Now.ToString();


string requete = "Insert into table_name (date_field) values (CONVERT(DATETIME,'"+sDate+"', 103))";

If you want the date in a string, try one of these:

Now.ToShortDate();
or
Now.ToLongDate();


You can use a custom format as well (e.g.):

DateTime d = new DateTime(1944, 06, 04);
string dday;
dday = String.Format("{0:MMM dd, yyyy}", d);