从字符串转换日期和/或时间时，转换失败

Question

string sqlstr2 = @"UPDATE CardLog SET Date=@Date,Time=@Time";
using (SqlConnection cn = new SqlConnection(DBAssist.ConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = sqlstr2;
cmd.Parameters.AddWithValue("@Date",DateTime.Now.ToLongDateString());
cmd.Parameters.AddWithValue("@Time",DateTime.Now.ToShortTimeString());
cn.Open();
cmd.ExecuteNonQuery();
}

然后就报错了，错误如题

Answer 1

@"UPDATE CardLog SET Date=@Date,Time=@Time";
没这么写的，要修改多个字段，应该写
@"UPDATE CardLog SET ([Date], [Time]) values(@Date, @Time)";
注意关键字还要转义。