如何在Asp.Net中检索group by date数据？

string connectionString = "YourConnectionString";
string query = "SELECT DATE_FORMAT(date_column, '%Y-%m-%d') AS date, COUNT(*) AS count FROM your_table GROUP BY DATE_FORMAT(date_column, '%Y-%m-%d')";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(query, connection);
    connection.Open();
    SqlDataReader reader = command.ExecuteReader();

    while (reader.Read())
    {
        string date = reader["date"].ToString();
        int count = Convert.ToInt32(reader["count"]);

        // 处理每个日期和对应的计数
    }

    reader.Close();
}