 |  |  |  |  |  |  |  |
Join multiple tables
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
By the way, i've checked the Column names and Table names. It is exactly what i've been using. So i don't know what went wrong.
Can you run the query straight in Access? You might get better error messages that what ADO.NET gives you.
The truth does not change according to our ability to stomach it.
•
•
Join Date: Nov 2006
Posts: 848
Reputation: 
Solved Threads: 120
Practically a Posting Shark
Hello,
u cant give the thresholdTable name in Dataset like that...
Proper Syntax is:
Regards
Veena
u cant give the thresholdTable name in Dataset like that...
Proper Syntax is:
Dim da As OleDbDataAdapter = New OleDbDataAdapter(sql, conn) da.Fill (MydataSet,"ThrTable")
Regards
Veena
•
•
•
•
u cant give the thresholdTable name in Dataset like that...
The truth does not change according to our ability to stomach it.
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
ur SQL Statemnt should contain all the 3 tables names:
Regards
Veena
ur SQL Statemnt should contain all the 3 tables names:
VB.NET Syntax (Toggle Plain Text)
Regards
Veena
|
Similar Threads
- generating one report from multiple tables (Visual Basic 4 / 5 / 6)
- Query multiple tables with duplicate data (MySQL)
- Searching for a record in multiple tables (VB.NET)
- Multiple Tables in a Database (Visual Basic 4 / 5 / 6)
- Delete from multiple tables (MySQL)
- Query multiple tables? (MySQL)
Other Threads in the VB.NET Forum
- Previous Thread: AxMSCommLib.AxMSComm' is not defined
- Next Thread: time??
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
.net .net2008 2008 access account advanced application array basic beginner browser button buttons center click code combo cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic excel exists fade filter forms generatetags gridview html images input insert intel internet listview map mobile module monitor msaccess net number objects open panel passingparameters pdf picturebox picturebox2 port position print printing problem regex right-to-left save search searchvb.net select serial settings shutdown socket sqldatbase sqlserver survey table temperature textbox timer timespan transparency txttoxmlconverter update user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year
