Click here to Skip to main content
15,389,427 members
Home / Discussions / Database
   

Database

 
QuestionOld school dbase II / clipper database, multiple left joins Pin
jkirkerx17-Apr-14 6:31
professionaljkirkerx17-Apr-14 6:31 
AnswerRe: Old school dbase II / clipper database, multiple left joins Pin
Jörgen Andersson17-Apr-14 10:38
professionalJörgen Andersson17-Apr-14 10:38 
General[SOLVED] Pin
jkirkerx17-Apr-14 10:49
professionaljkirkerx17-Apr-14 10:49 
GeneralRe: Old school dbase II / clipper database, multiple left joins Pin
jkirkerx17-Apr-14 11:03
professionaljkirkerx17-Apr-14 11:03 
QuestionSQL Query Pin
Syafiqah Zahirah17-Apr-14 6:00
MemberSyafiqah Zahirah17-Apr-14 6:00 
AnswerRe: SQL Query Pin
Richard Deeming17-Apr-14 6:59
mveRichard Deeming17-Apr-14 6:59 
GeneralRe: SQL Query Pin
Syafiqah Zahirah17-Apr-14 20:18
MemberSyafiqah Zahirah17-Apr-14 20:18 
GeneralRe: SQL Query Pin
Richard Deeming22-Apr-14 2:28
mveRichard Deeming22-Apr-14 2:28 
Try something like:
SQL
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:
C#
while (dr.Read())
{
    ...
    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."
- Homer


QuestionWhy connection is failing?! Pin
Jassim Rahma16-Apr-14 9:59
MemberJassim Rahma16-Apr-14 9:59 
QuestionRe: Why connection is failing?! Pin
Eddy Vluggen16-Apr-14 10:43
professionalEddy Vluggen16-Apr-14 10:43 
AnswerRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 10:50
MemberJassim Rahma16-Apr-14 10:50 
GeneralRe: Why connection is failing?! Pin
Mycroft Holmes16-Apr-14 12:57
professionalMycroft Holmes16-Apr-14 12:57 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 12:59
MemberJassim Rahma16-Apr-14 12:59 
GeneralRe: Why connection is failing?! Pin
Bernhard Hiller16-Apr-14 20:54
MemberBernhard Hiller16-Apr-14 20:54 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma16-Apr-14 22:38
MemberJassim Rahma16-Apr-14 22:38 
GeneralRe: Why connection is failing?! Pin
Eddy Vluggen17-Apr-14 0:26
professionalEddy Vluggen17-Apr-14 0:26 
GeneralRe: Why connection is failing?! Pin
Jassim Rahma17-Apr-14 0:42
MemberJassim Rahma17-Apr-14 0:42 
GeneralRe: Why connection is failing?! Pin
Eddy Vluggen17-Apr-14 10:46
professionalEddy Vluggen17-Apr-14 10:46 
Questionwhy looping is not starting from my start date? Pin
Jassim Rahma16-Apr-14 0:04
MemberJassim Rahma16-Apr-14 0:04 
AnswerRe: why looping is not starting from my start date? Pin
jimbowAX16-Apr-14 3:04
MemberjimbowAX16-Apr-14 3:04 
QuestionRe: why looping is not starting from my start date? Pin
Richard MacCutchan16-Apr-14 6:01
mveRichard MacCutchan16-Apr-14 6:01 
AnswerRe: why looping is not starting from my start date? Pin
Jassim Rahma16-Apr-14 6:14
MemberJassim Rahma16-Apr-14 6:14 
SuggestionRe: why looping is not starting from my start date? Pin
Richard MacCutchan16-Apr-14 6:29
mveRichard MacCutchan16-Apr-14 6:29 
GeneralRe: why looping is not starting from my start date? Pin
jimbowAX22-Apr-14 7:32
MemberjimbowAX22-Apr-14 7:32 
QuestionEmail Notification trhu SQL SERVER using SMTP Pin
Member 1075257815-Apr-14 21:09
MemberMember 1075257815-Apr-14 21:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.