Best Way convert C# DateTime format to a SQL DateTime

private void Test(DateTime startdate)

{

SqlConnection cn = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;");

DateTime enddate = startdate.AddDays(1);

SqlDataAdapter da = new SqlDataAdapter

(

@"SELECT Top 10 id ID, firstname Firstname , lastname Lastname, email Email, gamescore GameScore

FROM GameScores

WHERE createDate >= '" + startdate.ToString("yyyy-MM-dd 00:00:00") + "' and createDate < '" + enddate.ToString("yyyy-MM-dd 00:00:00") +

@"' ORDER BY gamescore desc", cn

);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

}

//datetime.ToString("yyyy-MM-dd 00:00:00") is useful :)