使用datetimepicker c#查询和过滤两个日期之间的数据

DateTime startDate = dateTimePicker1.Value;
DateTime endDate = dateTimePicker2.Value;

string connectionString = "YourConnectionString";
string query = "SELECT * FROM YourTable WHERE YourDateColumn BETWEEN @StartDate AND @EndDate";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(query, connection);
    command.Parameters.AddWithValue("@StartDate", startDate);
    command.Parameters.AddWithValue("@EndDate", endDate);

    connection.Open();

    // 执行查询操作并处理结果
    SqlDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
        // 处理查询结果
    }

    reader.Close();
}