示例#1
0
        private void btnAllBookings_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();

            dataGridViewBooking2.DataSource = dt;
            dataGridViewBooking2.ClearSelection();

            dt.Columns.Add("Bokningsnummer");
            dt.Columns.Add("Pris");
            dt.Columns.Add("Period");
            dt.Columns.Add("Pnr");
            dt.Columns.Add("Rumsnummer");
            dt.Columns.Add("RumsID");


            BookingController BController = new BookingController();

            List <Booking> bookingList = new List <Booking>();

            bookingList = BController.FindAllBookings();

            foreach (Booking b in bookingList)
            {
                DataRow row = dt.NewRow();
                row["Bokningsnummer"] = b.bookingNbr;
                row["Pris"]           = b.price;
                row["Period"]         = b.period;
                row["Pnr"]            = b.pnr;
                row["Rumsnummer"]     = b.roomNumber;
                row["RumsID"]         = b.roomId;
                dt.Rows.Add(row);
            }
        }