private void generateGraph()
{
using (CoffeeShopDatabaseEntities1 cse = new CoffeeShopDatabaseEntities1())
{
var query = (from product in cse.tblTransactionItems
group product by product.tblProduct.Description into g
select new { ProductID = g.Key, TotalUnitsSold = g.Count() }).ToList();
chart1.DataSource = query;
chart1.Series["Series1"].XValueMember = "ProductID";
chart1.Series["Series1"].YValueMembers = "TotalUnitsSold";
chart1.Series["Series1"].Name = "Products";
chart1.DataBind();
chart1.Show();
}
}