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