How to insert datetime property from asp.net c# to a date column in sql server?

Sorry, my first answer missed your question. Try adding the parameter by doing using the standard parameter system.

command.CommandText = "INSERT INTO FooTable (FooDate) VALUES (@FooDate)"; command.Parameters.AddWithValue("@FooDate", DateToUse.Date);

Using the .Date will only return the date part of the object. Here's another reference to it Date vs DateTime

If you're using a parametrized query, I have no trouble whatsoever to insert that DateTime from the ASP.NET calendar control into a SQL Server database table that contains a column of type DATE.

Use something like this:

// define INSERT statement - of course, yours will look quite different!
string insertStmt = "INSERT INTO dbo.DateTest(TheDate) VALUES(@DateValue);";

// set up connection and SqlCommand to do insert
using(SqlConnection conn = new SqlConnection("....your-connection-string-here...."))
using (SqlCommand cmd = new SqlCommand(insertStmt, conn))
{
     // add the parameters - the @DateValue - to the SqlCommand object and
     // define it's datatype (on the database) and set the value to be stored
     cmd.Parameters.Add("@DateValue", SqlDbType.Date).Value = Calendar1.SelectedDate;

     // open connection, execute command, close connection
     conn.Open();
     cmd.ExecuteNonQuery();
     conn.Close();
}

Try one thing first, try to insert 01/01/2012 in the column, because that could because of wrong culture.... it could be mm/dd/yyyy or dd/mm/yyyy

try this 01/01/2012 first and see if thats working.

thanks