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;
}
}