| | |
establishing connection with more than one database
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Sep 2007
Posts: 28
Reputation:
Solved Threads: 0
Hi!
I wish to specify more than one databases in my connection string in a vb.net project, in order to retrieve records from both of them.
For example,
I have 2 databases , database A and database B
I wish to retrieve the city field from the emp tables of both of them, like this
select a.dbo.emp.city from a.dbo.emp union select b.dbo.emp.city from b.dbo.emp
How is this possible?????
I wish to specify more than one databases in my connection string in a vb.net project, in order to retrieve records from both of them.
For example,
I have 2 databases , database A and database B
I wish to retrieve the city field from the emp tables of both of them, like this
select a.dbo.emp.city from a.dbo.emp union select b.dbo.emp.city from b.dbo.emp
How is this possible?????
•
•
Join Date: Sep 2007
Posts: 1,080
Reputation:
Solved Threads: 68
•
•
•
•
I wish to retrieve the city field from the emp tables of both of them, like this
select a.dbo.emp.city from a.dbo.emp union select b.dbo.emp.city from b.dbo.emp
How is this possible?????
VB.NET Syntax (Toggle Plain Text)
"SELECT a.dbo.emp.city, b.ado.emp.city FROM a.dbo.emp, b.dbo.emp"
VB.NET Syntax (Toggle Plain Text)
"SELECT database1.dbo.table.column, database2.dbo.table.column FROM database1.dbo.table, database2.dbo.table"
![]() |
Similar Threads
- JSP connection to database (JSP)
- database connection (ASP.NET)
- how to create new table in MS Access2003 database using VB6 (Visual Basic 4 / 5 / 6)
- Problem with database connection (JSP)
- Database Connection in Visual Studio 2005 (ASP.NET)
- direct remote sql connection (Visual Basic 4 / 5 / 6)
- This Database is a Monster (MS Access and FileMaker Pro)
- Establishing A connection between Three programs. (C++)
Other Threads in the VB.NET Forum
- Previous Thread: Duplicate print jobs using .NET
- Next Thread: Data Visualization requirement
| Thread Tools | Search this Thread |
.net .net2008 2008 access add advanced application array assignment basic beginner box browser button buttons center click client code combo convert cpu cuesent data database datagrid datagridview datetimepicker designer dissertation dissertations dissertationtopic eclipse editvb.net employees excel exists filter forms function html images isnumericfuntioncall listview map mobile module msaccess mssqlbackend mysql net number open page pan panel pdf picturebox picturebox2 port position print printing printpreview read record regex reuse right-to-left save search serial settings socket sorting sqldatbase sqlserver storedprocedure temp textbox timer timespan transparency txttoxmlconverter usercontol vb vb.net vba vbnet vista visual visualbasic visualbasic.net visualstudio.net web winsock wpf wrapingcode xml year






