Click here to Skip to main content
15,901,853 members
Home / Discussions / C#
   

C#

 
QuestionAn entity object cannot be referenced by multiple instances of IEntityChangeTracker Pin
Šangeet Šhah15-Apr-14 20:56
professionalŠangeet Šhah15-Apr-14 20:56 
AnswerRe: An entity object cannot be referenced by multiple instances of IEntityChangeTracker Pin
Dave Kreskowiak16-Apr-14 1:31
mveDave Kreskowiak16-Apr-14 1:31 
Questionhow to access built - in class Pin
Member 1034709215-Apr-14 18:54
Member 1034709215-Apr-14 18:54 
AnswerRe: how to access built - in class Pin
Mycroft Holmes15-Apr-14 20:08
professionalMycroft Holmes15-Apr-14 20:08 
AnswerRe: how to access built - in class Pin
OriginalGriff15-Apr-14 21:07
mveOriginalGriff15-Apr-14 21:07 
QuestionRegarding Tabs Pin
Mahesh Devikar15-Apr-14 17:43
Mahesh Devikar15-Apr-14 17:43 
AnswerRe: Regarding Tabs Pin
Dave Kreskowiak15-Apr-14 17:58
mveDave Kreskowiak15-Apr-14 17:58 
QuestionExport & Import database Pin
Member 1072402015-Apr-14 10:38
Member 1072402015-Apr-14 10:38 
AnswerRe: Export & Import database Pin
Richard MacCutchan15-Apr-14 11:57
mveRichard MacCutchan15-Apr-14 11:57 
AnswerRe: Export & Import database Pin
Bernhard Hiller15-Apr-14 22:17
Bernhard Hiller15-Apr-14 22:17 
QuestionIncorrect syntax near ',' Pin
Syafiqah Zahirah15-Apr-14 6:05
Syafiqah Zahirah15-Apr-14 6:05 
AnswerRe: Incorrect syntax near ',' Pin
Eddy Vluggen15-Apr-14 6:15
professionalEddy Vluggen15-Apr-14 6:15 
GeneralRe: Incorrect syntax near ',' Pin
Syafiqah Zahirah15-Apr-14 6:21
Syafiqah Zahirah15-Apr-14 6:21 
AnswerRe: Incorrect syntax near ',' Pin
Richard Andrew x6415-Apr-14 6:17
professionalRichard Andrew x6415-Apr-14 6:17 
GeneralRe: Incorrect syntax near ',' Pin
Syafiqah Zahirah15-Apr-14 6:32
Syafiqah Zahirah15-Apr-14 6:32 
AnswerRe: Incorrect syntax near ',' Pin
Pete O'Hanlon15-Apr-14 6:29
mvePete O'Hanlon15-Apr-14 6:29 
Member 10724507 wrote:
SELECT Environmnets.id, Environmnets.TempIn, Environmnets.tempOut, Environmnets.humidity, Environmnets.DateT, Environmnets.Deviceid, Environmnets.House

FROM Environmnets INNER JOIN TDevice ON Environmnets.Deviceid = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id

WHERE (Environmnets.DateT = (SELECT MAX(DateT) AS Expr1

FROM Environmnets AS Environmnets_1), TMushroomHouse.Name='"+ DropDownList1.Text + "'";
The issue is with the , before TMushroomHouse.Name. Is this meant to be an AND statement by any chance? By the way, you should really avoid concatenating things in like DropDownList1.Text to prevent opening your app up to SQL Injection Attacks.
GeneralRe: Incorrect syntax near ',' Pin
Syafiqah Zahirah15-Apr-14 6:40
Syafiqah Zahirah15-Apr-14 6:40 
Questionsend message using c#.net Pin
Member 1075021215-Apr-14 4:14
Member 1075021215-Apr-14 4:14 
QuestionRe: send message using c#.net Pin
ZurdoDev15-Apr-14 4:53
professionalZurdoDev15-Apr-14 4:53 
AnswerRe: send message using c#.net Pin
OriginalGriff15-Apr-14 5:18
mveOriginalGriff15-Apr-14 5:18 
Questionsend message using c#.net Pin
Member 1075021215-Apr-14 4:12
Member 1075021215-Apr-14 4:12 
Questioncreating multiple events in C# Pin
anilv202015-Apr-14 0:28
anilv202015-Apr-14 0:28 
AnswerRe: creating multiple events in C# Pin
Simon_Whale15-Apr-14 0:40
Simon_Whale15-Apr-14 0:40 
AnswerRe: creating multiple events in C# PinPopular
Pete O'Hanlon15-Apr-14 0:57
mvePete O'Hanlon15-Apr-14 0:57 
QuestionRegarding sending message using c# Pin
Member 1075021214-Apr-14 23:46
Member 1075021214-Apr-14 23:46 

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.