gagan

gagan

  • NA
  • 1
  • 0

dropdownlist data selection

Jun 26 2006 5:57 PM
Hello, I have two databases db1 and db2. Database db1 has table tbl1 containing fields empcode1 and salary. Database db2 has table tbl2 containing fields empcode2 and empname. I am showing empname from the tbl2 of database db2 in the dropdownlist-ddl1. On clicking submit button I want to display salary of all those employees whose empcode1 matches with empcode2 in the 2 tables of db1 and db2. So the empname in tbl2 should get converted into empcode2 internally & then match itself with corresponding empcode1 in table tbl1 How to handle the dropdownlist ddl1 for empname,empcode1 & empcode2? empcode, empcode1, empcode2 are of type varchar. Regards and Thanks

Answers (1)