将日期时间值插入SQL Server数据库(Insert date time value into SQL Server database)

 我正在尝试将日期时间选择器值插入到我的数据库中的DATETIME列中。 
 
 这是我的代码.. 
 
 myconstr = "Data Source=wind;Initial Catalog=TestDB;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False";
 myquery = "INSERT INTO DateTimeTB(MyDate) VALUES (@mydate)";

 using (SqlConnection connection = new SqlConnection(myconstr))
 {
     SqlCommand cmd = new SqlCommand(myquery);
     cmd.CommandType = CommandType.Text;
     cmd.Connection = connection;
     cmd.Parameters.Add(new SqlParameter("@mydate", SqlDbType.DateTime).Value = MyDTP01.Value);
     connection.Open();
     cmd.ExecuteNonQuery();
     connection.Close();
 }
 
 它给了我以下错误.. 
 
 
 
 SQL参数集合仅接受非null的SqlParameter类型对象，而不接受日期时间对象。 
 
 
 我怎样才能解决这个问题..？ 

I'm trying to insert date time picker value into a DATETIME column in my database. 
 
Here's my code..
 
 myconstr = "Data Source=wind;Initial Catalog=TestDB;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False";
 myquery = "INSERT INTO DateTimeTB(MyDate) VALUES (@mydate)";

 using (SqlConnection connection = new SqlConnection(myconstr))
 {
     SqlCommand cmd = new SqlCommand(myquery);
     cmd.CommandType = CommandType.Text;
     cmd.Connection = connection;
     cmd.Parameters.Add(new SqlParameter("@mydate", SqlDbType.DateTime).Value = MyDTP01.Value);
     connection.Open();
     cmd.ExecuteNonQuery();
     connection.Close();
 }
 
It gives me the following error..
 
 
 
The SQL parameter collection only accepts non-null SqlParameter type objects, not date time objects.
 
 
How can I fix this..?

原文：https://stackoverflow.com/questions/25010736