|Try something like:
SELECT TOP 1 House, DateT, TempIn, tempOut, Humidity, TMushroomHouse.Name As MushroomHouseName FROM Environmnets INNER JOIN TDevice ON Environmnets.Deviceid = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id WHERE TMushroomHouse.Name = @MushroomHouseName ORDER BY Environmnets.DateT DESC
This adds the
Name column from the
TMushroomHouse table as a new result column called
MushroomHouseName. You can then read it from your code and put it in a textbox:
MushroomHouseTextBox.Text = dr["MushroomHouseName"].ToString();
"These people looked deep within my soul and assigned me a number based on the order in which I joined."