Click here to Skip to main content
15,394,327 members
Home / Discussions / Database
   

Database

 
GeneralRe: would you use RDLC? Pin
Jassim Rahma20-Apr-14 12:15
MemberJassim Rahma20-Apr-14 12:15 
GeneralRe: would you use RDLC? Pin
Mycroft Holmes20-Apr-14 12:54
professionalMycroft Holmes20-Apr-14 12:54 
GeneralRe: would you use RDLC? Pin
Jassim Rahma20-Apr-14 22:04
MemberJassim Rahma20-Apr-14 22:04 
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 
Hye, I having a problem with this sql query..

string sql = "SELECT * 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)) AND TMushroomHouse.Name ='"+ DropDownList1.Text + "'";

SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand(sql, con);
// SqlDataReader dr = cmd.ExecuteReader();

try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
HouseTextBox.Text = dr["House"].ToString();
DateTTextBox.Text = dr["DateT"].ToString();
TempInTextBox.Text = dr["TempIn"].ToString();
TempOutTextBox.Text = dr["tempOut"].ToString();
HumidityTextBox.Text = dr["Humidity"].ToString();
}
}

There is no error occur when I run this code, but when I select home from dropdownlist, the data from database didn't display in the textbox. Anybody can help me?
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 
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 

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.