Click here to Skip to main content
11,496,146 members (809 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
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
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
0 Dnyaneshwar@Pune 692
1 RyanDev 230
2 CHill60 163
3 Sascha Lefèvre 145
4 Sergey Alexandrovich Kryukov 124
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2015
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