Click here to Skip to main content
12,077,753 members (48,897 online)
Rate this:
 
Please Sign up or sign in to vote.
i have 2 working databases. one is called EquipmentDB one is called EmployeeDB

I created another form. I want to key in the Company ID of the employee in the textbox and click a Button. The rest of the details of the employee will display in textbox or label as followed:

Name:
Department:

P.S: i have 2 of this field in my database.

After that there will be another textbox to type in the barcode of the equipment. Same thing, click a Button display the barcode details.

ItemName:
Category:

Is it possible to use 2 database in one form?
Posted 1-Jan-13 21:06pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

If you have your databases on different servers you can use two connection strings. But if you have your databases on the same server you can pass database name as a variable to your stored procedure and there you can create a dynamic query. For example:

Create Procedure CompanyDetails
(@companyID int,@databaseName varchar(50))
AS
BEGIN
declare @sql varchar(500)
set @sql = 'select * from ' + '[' + @databaseName +'].dbo.CompanyDetailsTable where companyId = ' + Convert(varchar(10),@companyID)
exec @sql
END
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160212.1 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100