Display Multiple Sets Of Data In THe Same Datagrid

  • Thread starter Thread starter Iain Wilson
  • Start date Start date
I

Iain Wilson

Hi Can anyone please advise if this is possible and if so how I would
go about it (a pointer to an example would be greatly appreciated).

Using C# - Web Application

I have a DropDownList with the following entries

Room A
Room B
All Rooms

The datasource is a single table containing a list of all room
bookings. (We have 5 meeting rooms)

If Room A or Room B are selected then the Datagrid below is it updated
to display all the bookings for the selected day for the selected
room. This works perfectly.


eg

From To Booked By
07.00.00 07.29.00 An Other
07.30.00 07.59.00 An Other
08.00.00 08.29.00 An Other
08.30.00 08.59.00
09.00.00 09.29.00
09.30.00 09.59.00

However what we need to do is when the user selects the 'All Rooms'
option then the bookings for all rooms will be displayed on the same
grid eg

Room A Room B
From To Booked By Booked By
07.00.00 07.29.00 An Other
07.30.00 07.59.00 An Other Somebody
08.00.00 08.29.00 An Other Somebody
08.30.00 08.59.00
09.00.00 09.29.00 Somebody
09.30.00 09.59.00

How do I populate the datagrid as above.

Any assistance would be appreciated

Best Regards

Iain
 
Back
Top