private void BookingReceipt_Load(object sender, EventArgs e) { SembawangSportEntities1 context = new SembawangSportEntities1(); //retrieve the booking in question from database List <Booking1> list = context.Booking1.Where(x => x.BookingID == bookingID).ToList(); crReceipt cr = new crReceipt(); cr.SetDataSource(list); crReceiptViewer.ReportSource = cr; }
private void TestForm_Load(object sender, EventArgs e) { SembawangSportEntities1 context = new SembawangSportEntities1(); var q = from x in context.Facility1 group x by x.FacilityType into g select new { FacilityType = g.Key }; }