如何通过C#在SQLite数据库中写入变量DateTime的值？

using System.Data.SQLite;

// 创建SQLite连接对象
SQLiteConnection connection = new SQLiteConnection("Data Source=your_database_path");

connection.Open();

// 创建SQL插入语句
string sql = "INSERT INTO your_table_name (date_column) VALUES (@date)";

// 创建SQLiteCommand对象
SQLiteCommand command = new SQLiteCommand(sql, connection);

// 添加参数并设置值
command.Parameters.AddWithValue("@date", yourDateTimeVariable);

command.ExecuteNonQuery();

connection.Close();