private void InitializeData() { var res = rs.GetReservations(active).Select(r => new { Id = r.Id, CheckIn = r.Start, CheckOut = r.End, ContactName = r.User.UserName == null ? "" : r.User.UserName, RoomType = r.Type.Name, Room = r.Room == null ? "" : r.Room.Nr.ToString() }).OrderByDescending(r => r.CheckIn).ToList(); var rooms = rs.GetRooms().Select(r => new { Nr = r.Nr, RoomType = r.Type == null ? "" : r.Type.Name }).ToList(); dataGridView2.DataSource = res; dataGridView1.DataSource = rooms; }