Click here to Skip to main content
15,350,244 members
Home / Discussions / Database
   

Database

 
AnswerRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
thatraja29-Apr-14 23:30
professionalthatraja29-Apr-14 23:30 
GeneralRe: Execute Oracle Procedure from VB.NET ORA-009000 error Pin
GuyThiebaut30-Apr-14 2:26
professionalGuyThiebaut30-Apr-14 2:26 
QuestionHow many types of lock exist in Sql server Pin
Tridip Bhattacharjee23-Apr-14 20:59
professionalTridip Bhattacharjee23-Apr-14 20:59 
AnswerRe: How many types of lock exist in Sql server Pin
Eddy Vluggen23-Apr-14 21:40
professionalEddy Vluggen23-Apr-14 21:40 
AnswerRe: How many types of lock exist in Sql server Pin
Corporal Agarn24-Apr-14 9:42
professionalCorporal Agarn24-Apr-14 9:42 
Questionconverter Pin
Member 1074305623-Apr-14 10:26
MemberMember 1074305623-Apr-14 10:26 
AnswerRe: converter Pin
Mycroft Holmes23-Apr-14 12:49
professionalMycroft Holmes23-Apr-14 12:49 
QuestionINNER JOIN Pin
Syafiqah Zahirah23-Apr-14 8:26
MemberSyafiqah Zahirah23-Apr-14 8:26 
Hello..can anyone help me on this.

I want to insert data based on the dropdownlist value. This is my database sql.
SQL
SELECT TOP (200) Actuators.id, Actuators.ActuatorInfo, Actuators.Fan, Actuators.Date, Actuators.DeviceId, Actuators.House, Actuators.DateView
FROM  Actuators INNER JOIN  TDevice ON Actuators.DeviceId = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id


If I want to insert data DateView into table Actuators, based on the dropdownlist for mushroom house name, how I can inner join with table TDevice and TMushroomHouse.
For example:"Insert into Actuators(DateView) Values (@DateView) INNER JOIN ..."
AnswerRe: INNER JOIN Pin
Eddy Vluggen23-Apr-14 11:25
professionalEddy Vluggen23-Apr-14 11:25 
AnswerRe: INNER JOIN Pin
Andrius Leonavicius23-Apr-14 13:11
professionalAndrius Leonavicius23-Apr-14 13:11 
QuestionSQL statement Pin
Syafiqah Zahirah23-Apr-14 6:47
MemberSyafiqah Zahirah23-Apr-14 6:47 
GeneralRe: SQL statement Pin
PIEBALDconsult23-Apr-14 6:56
professionalPIEBALDconsult23-Apr-14 6:56 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:00
MemberSyafiqah Zahirah23-Apr-14 7:00 
GeneralRe: SQL statement Pin
PIEBALDconsult23-Apr-14 7:19
professionalPIEBALDconsult23-Apr-14 7:19 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:25
MemberSyafiqah Zahirah23-Apr-14 7:25 
AnswerRe: SQL statement Pin
Eddy Vluggen23-Apr-14 6:57
professionalEddy Vluggen23-Apr-14 6:57 
GeneralRe: SQL statement Pin
Syafiqah Zahirah23-Apr-14 7:27
MemberSyafiqah Zahirah23-Apr-14 7:27 
AnswerRe: SQL statement Pin
TeddyLi26-Apr-14 1:33
MemberTeddyLi26-Apr-14 1:33 
QuestionCreate an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
jkirkerx21-Apr-14 11:03
professionaljkirkerx21-Apr-14 11:03 
AnswerRe: Create an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
Jörgen Andersson22-Apr-14 3:59
professionalJörgen Andersson22-Apr-14 3:59 
QuestionRe: Create an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
Eddy Vluggen22-Apr-14 6:57
professionalEddy Vluggen22-Apr-14 6:57 
AnswerRe: Create an AutoIncrement Column in a dbase/clipper file for Account Mate DOS Pin
Jörgen Andersson22-Apr-14 7:28
professionalJörgen Andersson22-Apr-14 7:28 
QuestionC# Windows application: connection string to connect to remote sql server 2008 using windows authentication Pin
AshwiniSH21-Apr-14 3:23
professionalAshwiniSH21-Apr-14 3:23 
AnswerRe: C# Windows application: connection string to connect to remote sql server 2008 using windows authentication Pin
thatraja21-Apr-14 4:12
professionalthatraja21-Apr-14 4:12 
Questionwould you use RDLC? Pin
Jassim Rahma18-Apr-14 12:51
MemberJassim Rahma18-Apr-14 12:51 

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.