Question: I would like to union 2 tables and display all in a datagrid:

* tblReservation (ID, StartTime, EndTime, SchoolID, AccomodationID)
* tblMeeting (ID, StartTime, EndTime, Subject, Location)

In the datagrid I have 2 matching columns (StartTime, EndTime) and 2 different columns. Still I want to unite these 2 tables and set column 3 for School/Subject and column 4 for Accomodation/Location.

In PHP I know you can set names for the fields you get by using 

```
SELECT x AS name

```

but I am not very familiar with the LINQ-syntax.

Here I get the data from tblReservation from the date I've selected in the month calendar:

```
var vReservation = (from oReservation in clsApplication._oDBConnection.tblReservations
    where oReservation.StartTime.Value.Date >= mcCalendar.SelectionRange.Start.Date
    && oReservation.StartTime.Value.Date < cCalendar.SelectionRange.Start.Date.AddHours(24)
    orderby oReservation.StartTime ascending
    select oReservation);

foreach (var oReservation in vReservation)
{
    build the datagrid
}

```

How can I add the other table to this loop?

Answer: 
Check out the `DeviceStatus` class.

Have a look at [MSDN](http://msdn.microsoft.com/en-us/library/ff941122%28v=VS.92%29.aspx) about it. 

**Added** - after first comment

Check out [`System.Environment`](http://msdn.microsoft.com/en-us/library/system.environment%28v=VS.95%29.aspx)

```
System.Environment.OSVersion

```
What about using 

`Environment.OSVersion`

[MSDN Article](http://msdn.microsoft.com/en-us/library/system.environment.osversion.aspx)