Загрузка данных


private void LoadReport(int days)
{
    using (SQLiteConnection connection =
        new SQLiteConnection(connectionString))
    {
        connection.Open();

        string sql = @"
        SELECT *
        FROM Products
        WHERE date(ExpirationDate)
        BETWEEN date('now')
        AND date('now', '+' || @days || ' day')";

        SQLiteDataAdapter adapter =
            new SQLiteDataAdapter(sql, connection);

        adapter.SelectCommand.Parameters
            .AddWithValue("@days", days);

        DataTable table = new DataTable();

        adapter.Fill(table);

        dgvProducts.DataSource = table;
    }
}