使用C#将日期和时间传递给SQL Server

using System;
using System.Data;
using System.Data.SqlClient;
using System.Threading;

class Program
{
    static void Main()
    {
        // 设置连接字符串和命令
        string connectionString = "YOUR_CONNECTION_STRING";
        string command = "SELECT * FROM YOUR_TABLE";

        // 添加日期和时间参数
        command += " WHERE DateTimeColumn BETWEEN @start_date AND @end_date";

        // 创建 SqlConnection 和 SqlCommand
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            SqlCommand command = new SqlCommand(command, connection);

            // 添加日期和时间参数
            SqlParameter startParam = new SqlParameter("@start_date", SqlDbType.DateTime);
            startParam.Value = DateTime.Now.Date.AddDays(-10);
            command.Parameters.Add(startParam);

            SqlParameter endParam = new SqlParameter("@end_date", SqlDbType.DateTime);
            endParam.Value = DateTime.Now.Date;
            command.Parameters.Add(endParam);

            // 执行查询
            SqlDataReader reader = command.ExecuteReader();

            // 读取数据
            while (reader.Read())
            {
                // 输出结果
                Console.WriteLine(reader.GetString(0));
            }
        }
    }
}